protected void Page_Load(object sender,EventArgs e) { sample = sampleService.GetSample(Request["did"].ToInt32()); sampledesc = sample == null ? "暂无" : string.Format("{0} --> {1}({2})",sample.ProjName,sample.Name,sample.SerialNum); if(!IsPostBack){ SetFields(); Bind(); } }
protected void Page_Load(object sender,EventArgs e) { if(Request.QueryString["id"] != null && Request.QueryString["id"] != ""){ Sid = Request.QueryString["id"]; Sample samplemodel = new Sample(); samplemodel = _SampleService.GetSample(Convert.ToInt32(Sid)); ProjId = samplemodel.ProjId; Pid = samplemodel.ProjUniqueNum; Sn = GetMD5("Manage"); } }
protected void Page_Load(object sender,EventArgs e) { if(Request.QueryString["id"] != null && Request.QueryString["id"] != ""){ Sid = Request.QueryString["id"]; samplemodel = _SampleService.GetSample(Convert.ToInt32(Sid)); Label1.Text = samplemodel.ProjName; Label2.Text = samplemodel.Name; Label11.Text = samplemodel.SampleTypeName; Label3.Text = samplemodel.SerialNum; Label4.Text = samplemodel.JGBW; Label5.Text = samplemodel.WTDW; Label6.Text = samplemodel.SGDW; Label7.Text = samplemodel.JZDW; Label8.Text = samplemodel.JZR; Label9.Text = samplemodel.JZTime.ToString("yyyy-MM-dd hh:mm:ss"); Label10.Text = "经度(" + samplemodel.Longitude + ") 纬度(" + samplemodel.Latitude + ")"; } }
protected void Page_Load(object sender,EventArgs e) { if(Request.QueryString["id"] != null && Request.QueryString["id"] != ""){ sid = Request.QueryString["id"].Trim(); Sample samplemodel = new Sample(); samplemodel = _SampleService.GetSample(Convert.ToInt32(sid)); projname = samplemodel.ProjName; Name = samplemodel.Name; SerialNum = samplemodel.SerialNum; JGBW = samplemodel.JGBW; WTDW = samplemodel.WTDW; SGDW = samplemodel.SGDW; JZDW = samplemodel.JZDW; JZR = samplemodel.JZR; JYR = samplemodel.JYR; Status = GetStatus(samplemodel.Status); JZTime = samplemodel.JZTime.ToString("yyyy-MM-dd hh:mm:ss"); LonLatitude = "经度(" + samplemodel.Longitude + ") 纬度(" + samplemodel.Latitude + ")"; } }
private void AddSample() { try{ string projId = GetRequest("projid"); bool existProject = ExistProject(projId); if(!existProject){ throw new Exception("指定工程不存在"); } Sample model = new Sample { ProjId = projId, Name = GetRequest("name"), SerialNum = GetRequest("serialnum"), JGBW = GetRequest("jgbw"), WTDW = GetRequest("wtdw"), SGDW = GetRequest("sgdw"), JZDW = GetRequest("jzdw"), JZR = GetRequest("jzr"), JYR = GetRequest("jyr"), Status = 0, FileData = GetRequest("filename"), Photo = GetRequest("photo"), SampleType = GetRequest("sampletype").ToInt32(), EPC = GetRequest("epc"), QYR = GetRequest("qyr") }; //GW_TemplateService _GW_TemplateService = new GW_TemplateService(); //GW_Template gw_template = _GW_TemplateService.GetSampleByTemplateName(model.Name); //if (gw_template!=null) //{ // model.FileData = gw_template.filedata; //} model.Sid = _SampleService.AddSample(model); Json(model); } catch(Exception ex){ Json(new {errorMsg = ex.Message}); } }
public int Add(Sample model) { string cmdText = @" DECLARE @NEWID INT INSERT INTO [Sample] (ProjId,Name,SerialNum,JGBW,WTDW,SGDW,JZDW,JZR,JYR,Status,CreateTime,FileData,Photo,SampleType,EPC,JZTime,QYR,Latitude,Longitude,PhoneNum) values (@ProjId,@Name,@SerialNum,@JGBW,@WTDW,@SGDW,@JZDW,@JZR,@JYR,@Status,GETDATE(),@FileData,@Photo,@SampleType,@EPC,GETDATE(),@QYR,@Latitude,@Longitude,@PhoneNum) SET @NEWID=@@IDENTITY SELECT @NEWID"; SqlParameter[] parameters = { SqlParamHelper.MakeInParam("@ProjId",SqlDbType.VarChar,40,model.ProjId), SqlParamHelper.MakeInParam("@Name",SqlDbType.VarChar,120,model.Name), SqlParamHelper.MakeInParam("@SerialNum",SqlDbType.VarChar,40,model.SerialNum), SqlParamHelper.MakeInParam("@JGBW",SqlDbType.VarChar,120,model.JGBW), SqlParamHelper.MakeInParam("@WTDW",SqlDbType.VarChar,120,model.WTDW), SqlParamHelper.MakeInParam("@SGDW",SqlDbType.VarChar,120,model.SGDW), SqlParamHelper.MakeInParam("@JZDW",SqlDbType.VarChar,120,model.JZDW), SqlParamHelper.MakeInParam("@JZR",SqlDbType.VarChar,60,model.JZR), SqlParamHelper.MakeInParam("@JYR",SqlDbType.VarChar,60,model.JYR), SqlParamHelper.MakeInParam("@Status",SqlDbType.SmallInt,4,model.Status), SqlParamHelper.MakeInParam("@FileData",SqlDbType.Text,10000,model.FileData), SqlParamHelper.MakeInParam("@Photo",SqlDbType.VarChar,200,model.Photo), SqlParamHelper.MakeInParam("@SampleType",SqlDbType.VarChar,50,model.SampleType), SqlParamHelper.MakeInParam("@EPC",SqlDbType.VarChar,20,model.EPC), SqlParamHelper.MakeInParam("@QYR",SqlDbType.VarChar,50,model.QYR), SqlParamHelper.MakeInParam("@Latitude",SqlDbType.VarChar,50,model.Latitude), SqlParamHelper.MakeInParam("@Longitude",SqlDbType.VarChar,50,model.Longitude), SqlParamHelper.MakeInParam("@PhoneNum",SqlDbType.VarChar,20,model.PhoneNum) }; int id = 0; using (IDataReader dataReader = SqlHelper.ExecuteReader(WriteConnectionString,CommandType.Text,cmdText,parameters)){ if(dataReader.Read()){ object obj = dataReader[0]; if(obj != null && obj != DBNull.Value){ id = Convert.ToInt32(obj); } } } return id; }
/// <summary> /// 保存信息 /// </summary> /// <returns></returns> private bool UpdateSampleFromBind() { try{ string JZR = ""; UserInfo currentUserInfo = new UserInfo(); currentUserInfo = UserContext.Instance.CurrentUser; if(null != currentUserInfo) JZR = currentUserInfo.TrueName; int sid = Convert.ToInt32(Sid); Sample model = new Sample(); model = _SampleService.GetSample(sid); model.JZR = JZR; model.Photo = "/upfile/" + ProjId + "_" + Sid + "_" + FileName; model.EPC = EPC.Value; model.JZTime = DateTime.Now; model.Status = 1; //待检测 return _SampleService.UpdateSample(model); } catch{ return false; } }
private void UpdateSample() { try{ int sid = GetRequest("sid").ToInt32(); Sample model = new Sample(); model = _SampleService.GetSample(sid); if(GetRequestString("projid") != "") model.ProjId = GetRequestString("projid"); if(GetRequest("name") != "") model.Name = GetRequest("name"); if(GetRequest("serialnum") != "") model.SerialNum = GetRequest("serialnum"); if(GetRequest("jgbw") != "") model.JGBW = GetRequest("jgbw"); if(GetRequest("wtdw") != "") model.WTDW = GetRequest("wtdw"); if(GetRequest("sgdw") != "") model.SGDW = GetRequest("sgdw"); if(GetRequest("jzdw") != "") model.JZDW = GetRequest("jzdw"); if(GetRequest("jzr") != "") model.JZR = GetRequest("jzr"); if(GetRequest("jyr") != "") model.JYR = GetRequest("jyr"); if(GetRequest("status") != "") model.Status = GetRequest("status").ToInt32(); if(GetRequest("filedata") != "") model.FileData = GetRequest("filedata"); if(GetRequest("photo") != "") model.Photo = GetRequest("photo"); if(GetRequest("sampletype") != "") model.SampleType = GetRequest("sampletype").ToInt32(); if(GetRequest("epc") != "") model.EPC = GetRequest("epc"); if(GetRequest("qyr") != "") model.QYR = GetRequest("qyr"); if(_SampleService.UpdateSample(model)){ Json(model); } else{ Json(new {errorMsg = "修改失败!"}); } } catch(Exception ex){ LogHelper.WriteException(ex.Message,ex); Json(new {errorMsg = ex.Message}); } }
public int Update(Sample model) { string cmdText = @"UPDATE [Sample] SET ProjId=@ProjId,Name=@Name,SerialNum=@SerialNum,JGBW=@JGBW,WTDW=@WTDW ,SGDW=@SGDW,JZDW=@JZDW,JZR=@JZR,JYR=@JYR,Status=@Status,FileData=@FileData ,Photo=@Photo,SampleType=@SampleType,EPC=@EPC,QYR=@QYR,Latitude=@Latitude,Longitude=@Longitude,PhoneNum=@PhoneNum,JZTime=GETDATE() WHERE Sid=@Sid"; SqlParameter[] parameters = { SqlParamHelper.MakeInParam("@Sid",SqlDbType.Int,4,model.Sid), SqlParamHelper.MakeInParam("@ProjId",SqlDbType.VarChar,40,model.ProjId), SqlParamHelper.MakeInParam("@Name",SqlDbType.VarChar,120,model.Name), SqlParamHelper.MakeInParam("@SerialNum",SqlDbType.VarChar,40,model.SerialNum), SqlParamHelper.MakeInParam("@JGBW",SqlDbType.VarChar,120,model.JGBW), SqlParamHelper.MakeInParam("@WTDW",SqlDbType.VarChar,120,model.WTDW), SqlParamHelper.MakeInParam("@SGDW",SqlDbType.VarChar,120,model.SGDW), SqlParamHelper.MakeInParam("@JZDW",SqlDbType.VarChar,120,model.JZDW), SqlParamHelper.MakeInParam("@JZR",SqlDbType.VarChar,60,model.JZR), SqlParamHelper.MakeInParam("@JYR",SqlDbType.VarChar,60,model.JYR), SqlParamHelper.MakeInParam("@Status",SqlDbType.SmallInt,4,model.Status), SqlParamHelper.MakeInParam("@FileData",SqlDbType.Text,10000,model.FileData), SqlParamHelper.MakeInParam("@Photo",SqlDbType.VarChar,200,model.Photo), SqlParamHelper.MakeInParam("@SampleType",SqlDbType.VarChar,50,model.SampleType), SqlParamHelper.MakeInParam("@EPC",SqlDbType.VarChar,20,model.EPC), SqlParamHelper.MakeInParam("@QYR",SqlDbType.VarChar,50,model.QYR), SqlParamHelper.MakeInParam("@Latitude",SqlDbType.VarChar,50,model.Latitude), SqlParamHelper.MakeInParam("@Longitude",SqlDbType.VarChar,50,model.Longitude), SqlParamHelper.MakeInParam("@PhoneNum",SqlDbType.VarChar,20,model.PhoneNum) }; return SqlHelper.ExecuteNonQuery(WriteConnectionString,CommandType.Text,cmdText,parameters); }
public bool UpdateSample(Sample model) { return _SampleRepository.Update(model) > 0; }
public int AddSample(Sample model) { return _SampleRepository.Add(model); }