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);
}