| | |
|---|
| | | //search = search.Substring(3);//截取索引2后面的字符 |
|---|
| | | // --------------查询指定数据-------------- |
|---|
| | | var total = 0; //总条数 |
|---|
| | | var sql = @"select A.code,A.name,A.eqptype_code,B.name as eqptype_name,A.eqpgroup_code,G.name as eqpgroup_name,A.enable, |
|---|
| | | A.input_date,A.wksp_code,T.org_name as wksp_name,A.Line_code,L.org_name as Line_name,A.opc_uom,A.operation_ration,A.lm_user,A.lm_date |
|---|
| | | var sql = @"select A.id,A.code,A.name,A.eqptype_code,B.name as eqptype_name,A.eqpgroup_code,G.name as eqpgroup_name,A.enable, |
|---|
| | | A.input_date,A.wksp_code,T.org_name as wksp_name,A.Line_code,L.org_name as Line_name,A.opc_uom,A.operation_ration,U.username as lm_user,A.lm_date |
|---|
| | | from TEqpInfo A |
|---|
| | | left join TEqpType B on A.eqptype_code=B.code |
|---|
| | | left join TEqpGroup G on A.eqpgroup_code=G.code |
|---|
| | | left join TOrganization T on A.wksp_code=T.org_code |
|---|
| | | left join TOrganization L on A.Line_code=L.org_code |
|---|
| | | left join TUser U on A.lm_user=U.usercode |
|---|
| | | where A.is_delete<>'1' " + search; |
|---|
| | | var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total); |
|---|
| | | mes.code = "200"; |
|---|
| | |
|---|
| | | if (operType == "Update") |
|---|
| | | { |
|---|
| | | var sql = @"update TEqpInfo set name=@devicename,eqptype_code=@devicetype,eqpgroup_code=@devicegroup,input_date=@importdate, |
|---|
| | | wksp_code=@workshop,line_code=@linecode,enable=@status,operation_ration=@ratio,lm_user=@usercode,lm_date=@CreateDate, |
|---|
| | | wksp_code=@workshop,line_code=@linecode,enable=@status,operation_ration=@ratio,lm_user=@usercode,lm_date=@CreateDate |
|---|
| | | where id=@deviceid"; |
|---|
| | | dynamicParams.Add("@deviceid", deviceid); |
|---|
| | | dynamicParams.Add("@devicename", devicename); |
|---|
