/// <summary> /// 获取删除时插入日志表sql /// </summary> /// <param name="modelInfo"></param> /// <param name="userId"></param> /// <returns></returns> protected override string GetInsertDeleteHistory(XModelBase modelInfo, string userId) { XEquipmentCheckInfo info = modelInfo as XEquipmentCheckInfo; string sql = "Insert Into " + this.HistoryTableName + "(RID,EquipmentType,EquipmentCustId,EquipmentName,FactoryNo,Spec,Model,FactoryName,SourceTime,UseTime,SourceCustId,SourceTypeId,EquipmentStatusId,SignStatus,Quanlity,LinkMan,Tel,Email,CheckAccord,LastCheckDate,CheckResult,ValidDate,CertNo,EquipmentDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,EquipmentNo,BillNo,OperateUserId,Operate,OperateTime,NewID) SELECT RID,EquipmentType,EquipmentCustId,EquipmentName,FactoryNo,Spec,Model,FactoryName,SourceTime,UseTime,SourceCustId,SourceTypeId,EquipmentStatusId,SignStatus,Quanlity,LinkMan,Tel,Email,CheckAccord,LastCheckDate,CheckResult,ValidDate,CertNo,EquipmentDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,EquipmentNo,BillNo,'" + userId + "','删除',getdate(),newid() FROM " + this.TableName + " WHERE " + this.PrimaryKey + "='" + info.RID + "'"; return(sql); }
/// <summary> /// 获取插入sql /// </summary> /// <param name="modelInfo"></param> /// <returns></returns> public override string GetInsertSql(XModelBase modelInfo) { XEquipmentCheckInfo info = modelInfo as XEquipmentCheckInfo; string sql = "Insert Into " + this.TableName + "(RID,EquipmentType,EquipmentCustId,EquipmentName,FactoryNo,Spec,Model,FactoryName,SourceTime,UseTime,SourceCustId,SourceTypeId,EquipmentStatusId,SignStatus,Quanlity,LinkMan,Tel,Email,CheckAccord,LastCheckDate,CheckResult,ValidDate,CertNo,EquipmentDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,EquipmentNo,BillNo)Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',{14},'{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}',{26},'{27}',{28},'{29}','{30}')"; sql = String.Format(sql, info.RID, info.EquipmentType, info.EquipmentCustId, info.EquipmentName, info.FactoryNo, info.Spec, info.Model, info.FactoryName, info.SourceTime, info.UseTime, info.SourceCustId, info.SourceTypeId, info.EquipmentStatusId, info.SignStatus, info.Quanlity, info.LinkMan, info.Tel, info.Email, info.CheckAccord, info.LastCheckDate, info.CheckResult, info.ValidDate, info.CertNo, info.EquipmentDesc, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion(), info.EquipmentNo, info.BillNo); return(sql); }
/// <summary> /// 自定义修改校验 /// </summary> /// <param name="modelInfo"></param> /// <returns></returns> protected override string GetValidateUpdateCustom(XModelBase modelInfo) { string validateInfo = string.Empty; XEquipmentCheckInfo equipmentcheck = modelInfo as XEquipmentCheckInfo; if (equipmentcheck == null) { return(this.GetNotRightType()); } return(string.Empty); }
/// <summary> /// 获取更新Sql /// </summary> /// <param name="modelInfo"></param> /// <returns></returns> public override string GetUpdateSql(XModelBase modelInfo) { string sql = String.Empty; XEquipmentCheckInfo info = modelInfo as XEquipmentCheckInfo; sql = "Update " + this.TableName + " Set EquipmentType='{0}',EquipmentCustId='{1}',EquipmentName='{2}',FactoryNo='{3}',Spec='{4}',Model='{5}',FactoryName='{6}',SourceTime='{7}',UseTime='{8}',SourceCustId='{9}',SourceTypeId='{10}',EquipmentStatusId='{11}',SignStatus='{12}',Quanlity={13},LinkMan='{14}',Tel='{15}',Email='{16}',CheckAccord='{17}',LastCheckDate='{18}',CheckResult='{19}',ValidDate='{20}',CertNo='{21}',EquipmentDesc='{22}',Remark='{23}',UpdateUserId='{24}',UpdateTime={25},EquipmentNo='{26}',BillNo='{27}' Where RID='{28}'"; sql = string.Format(sql, info.EquipmentType, info.EquipmentCustId, info.EquipmentName, info.FactoryNo, info.Spec, info.Model, info.FactoryName, info.SourceTime, info.UseTime, info.SourceCustId, info.SourceTypeId, info.EquipmentStatusId, info.SignStatus, info.Quanlity, info.LinkMan, info.Tel, info.Email, info.CheckAccord, info.LastCheckDate, info.CheckResult, info.ValidDate, info.CertNo, info.EquipmentDesc, info.Remark, info.UpdateUserId, this.GetServerTimeFuncion(), info.EquipmentNo, info.BillNo, info.RID); return(sql); }
protected override string GetValueMember(XModelBase selectedModel) { XEquipmentCheckInfo info = selectedModel as XEquipmentCheckInfo; if (info != null) { return(info.RID); } else { return(string.Empty); } }
protected override string GetDisplayMember(Model.XModelBase selectedModel) { XEquipmentCheckInfo info = selectedModel as XEquipmentCheckInfo; if (info != null) { return(info.EquipmentName); } else { return(string.Empty); } }
protected override void grdData_Click(object sender, EventArgs e) { if (this.grdData.CurrentRow != null) { XEquipmentCheckInfo checkInfo = this.grdData.CurrentRow.DataRow as XEquipmentCheckInfo; XEquipmentReceiveBusiness business = new XEquipmentReceiveBusiness(); IList <XModelBase> receiveInfos = business.GetTop5Checked(checkInfo.RID); this.grdEquipmentRecieve.DataSource = receiveInfos; this.grdEquipmentRecieve.AutoSizeColumns(); } }
/// <summary> /// 将数据行转换为实体 /// </summary> /// <param name="modelRow">数据行记录</param> /// <returns>实体信息</returns> protected override void DataRow2ModelBase(XModelBase modelInfo, DataRow modelRow) { XEquipmentCheckInfo info = modelInfo as XEquipmentCheckInfo; info.ID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键 info.RID = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "RID")); //主键 info.EquipmentType = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "EquipmentType")); //设备类型 info.EquipmentCustId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "EquipmentCustId")); //送检单位 info.EquipmentName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "EquipmentName")); //设备名称 info.FactoryNo = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FactoryNo")); //出厂编号 info.Spec = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Spec")); //规格 info.Model = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Model")); //型号 info.FactoryName = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "FactoryName")); //制造单位 info.SourceTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SourceTime")); //溯源时间 info.UseTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UseTime")); //使用时间 info.SourceCustId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SourceCustId")); //溯源单位 info.SourceTypeId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SourceTypeId")); //溯源方式 info.EquipmentStatusId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "EquipmentStatusId")); //设备状态 info.SignStatus = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "SignStatus")); //标识状态 info.Quanlity = XHelper.GetInt(XDataRowHelper.GetFieldValue(modelRow, "Quanlity")); //数量 info.LinkMan = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "LinkMan")); //联系人 info.Tel = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Tel")); //电话 info.Email = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Email")); //电子邮件 info.CheckAccord = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckAccord")); //坚定依据 info.LastCheckDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "LastCheckDate")); //最后检定日期 info.CheckResult = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CheckResult")); //坚定结论 info.ValidDate = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "ValidDate")); //有效日期 info.CertNo = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "CertNo")); //检定证书编号 info.EquipmentDesc = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "EquipmentDesc")); //设备描述 info.Remark = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "Remark")); //备注信息 info.InputUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputUserId")); //录入人 info.InputTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "InputTime")); //录入时间 info.UpdateUserId = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateUserId")); //修改人 info.UpdateTime = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "UpdateTime")); //修改时间 info.EquipmentNo = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "EquipmentNo")); // info.BillNo = XHelper.GetString(XDataRowHelper.GetFieldValue(modelRow, "BillNo")); // }
public bool Checked(XModelBase model, string userId) { DbConnection sqlConn = this.m_DataAccess.Connection; DbTransaction trans = null; try { if (sqlConn.State == ConnectionState.Closed) { sqlConn.Open(); } trans = sqlConn.BeginTransaction(); string sql = string.Empty; XEquipmentCheckInfo info = model as XEquipmentCheckInfo; sql = "Insert Into " + this.TableName + "(RID,EquipmentType,EquipmentCustId,EquipmentName,FactoryNo,Spec,Model,FactoryName,SourceTime,UseTime,SourceCustId,SourceTypeId,EquipmentStatusId,SignStatus,Quanlity,LinkMan,Tel,Email,CheckAccord,LastCheckDate,CheckResult,ValidDate,CertNo,EquipmentDesc,Remark,InputUserId,InputTime,UpdateUserId,UpdateTime,EquipmentNo,BillNo)Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}',{14},'{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}','{25}',{26},'{27}',{28},'{29}','{30}')"; sql = String.Format(sql, info.RID, info.EquipmentType, info.EquipmentCustId, info.EquipmentName, info.FactoryNo, info.Spec, info.Model, info.FactoryName, info.SourceTime, info.UseTime, info.SourceCustId, info.SourceTypeId, info.EquipmentStatusId, info.SignStatus, info.Quanlity, info.LinkMan, info.Tel, info.Email, info.CheckAccord, info.LastCheckDate, info.CheckResult, info.ValidDate, info.CertNo, info.EquipmentDesc, info.Remark, info.InputUserId, this.GetServerTimeFuncion(), info.UpdateUserId, this.GetServerTimeFuncion(), info.EquipmentNo, info.BillNo); //if (receiveInfo.ReportFileFullName != string.Empty) //{ // //上传附件 // DbCommand fileCommand = this.GetFileCommand(receiveInfo); // fileCommand.Connection = sqlConn; // fileCommand.Transaction = trans; // DbDataReader reader = fileCommand.ExecuteReader(); // reader.Close(); //} sql += ";"; //XEquipmentReceiveInfo inforev = modelrev as XEquipmentReceiveInfo; XVEquipmentReceiveInfo inforev = FillEquipmentReceiveInfo4Add(model as XVEquipmentCheckInfo, userId); string sql2 = GetInsertSql4rev(inforev); sql = sql + sql2; DbCommand cmd = this.m_DataAccess.GetDbCommand(); cmd.Connection = sqlConn; cmd.CommandText = sql; cmd.Transaction = trans; bool isSuccess = cmd.ExecuteNonQuery() > 0; trans.Commit(); return(isSuccess); } catch (Exception ex) { XMessageBox.ShowError(ex.Message); XErrorLogTool.WriteLog(ex.ToString()); trans.Rollback(); } finally { if (sqlConn.State == ConnectionState.Open) { sqlConn.Close(); } } return(false); }