/// <summary> /// 更新一条数据 /// </summary> public bool Update(DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update T_FileList_SignatureLog set "); strSql.Append("FileListID=@FileListID,"); strSql.Append("SingleProjectID=@SingleProjectID,"); strSql.Append("Signature_DT=@Signature_DT,"); strSql.Append("Signature_UserID=@Signature_UserID,"); strSql.Append("Signature_UserRoleCode=@Signature_UserRoleCode,"); strSql.Append("FileListTmpID=@FileListTmpID,"); strSql.Append("Message=@Message,"); strSql.Append("OperationType=@OperationType,"); strSql.Append("SignatureFinishFlag=@SignatureFinishFlag,"); strSql.Append("SignatureFinish_DT=@SignatureFinish_DT "); strSql.Append(" where SignatureLogID=@SignatureLogID "); SqlParameter[] parameters = { new SqlParameter("@FileListID", SqlDbType.Int, 8), new SqlParameter("@SingleProjectID", SqlDbType.Int, 8), new SqlParameter("@Signature_DT", SqlDbType.DateTime), new SqlParameter("@Signature_UserID", SqlDbType.Int, 8), new SqlParameter("@Signature_UserRoleCode", SqlDbType.NVarChar, 50), new SqlParameter("@FileListTmpID", SqlDbType.Int, 8), new SqlParameter("@Message", SqlDbType.NVarChar, 500), new SqlParameter("@OperationType", SqlDbType.NVarChar, 50), new SqlParameter("@SignatureLogID", SqlDbType.Int, 8), new SqlParameter("@SignatureFinishFlag", SqlDbType.NVarChar, 1), new SqlParameter("@SignatureFinish_DT", SqlDbType.DateTime) }; parameters[0].Value = model.FileListID; parameters[1].Value = model.SingleProjectID; parameters[2].Value = model.Signature_DT; parameters[3].Value = model.Signature_UserID; parameters[4].Value = model.Signature_UserRoleCode; parameters[5].Value = model.FileListTmpID; parameters[6].Value = model.Message; parameters[7].Value = model.OperationType; parameters[8].Value = model.SignatureLogID; parameters[9].Value = model.SignatureFinishFlag; parameters[10].Value = model.SignatureFinish_DT; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL DataRowToModel(DataRow row) { DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL model = new DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL(); if (row != null) { if (row["SignatureLogID"] != null && row["SignatureLogID"].ToString() != "") { model.SignatureLogID = int.Parse(row["SignatureLogID"].ToString()); } if (row["FileListID"] != null && row["FileListID"].ToString() != "") { model.FileListID = int.Parse(row["FileListID"].ToString()); } if (row["SingleProjectID"] != null && row["SingleProjectID"].ToString() != "") { model.SingleProjectID = int.Parse(row["SingleProjectID"].ToString()); } if (row["Signature_DT"] != null && row["Signature_DT"].ToString() != "") { model.Signature_DT = DateTime.Parse(row["Signature_DT"].ToString()); } if (row["Signature_UserID"] != null && row["Signature_UserID"].ToString() != "") { model.Signature_UserID = int.Parse(row["Signature_UserID"].ToString()); } if (row["Signature_UserRoleCode"] != null) { model.Signature_UserRoleCode = row["Signature_UserRoleCode"].ToString(); } if (row["FileListTmpID"] != null && row["FileListTmpID"].ToString() != "") { model.FileListTmpID = int.Parse(row["FileListTmpID"].ToString()); } if (row["Message"] != null) { model.Message = row["Message"].ToString(); } if (row["OperationType"] != null) { model.OperationType = row["OperationType"].ToString(); } if (row["SignatureFinishFlag"] != null) { model.SignatureFinishFlag = row["SignatureFinishFlag"].ToString(); } if (row["SignatureFinish_DT"] != null && row["SignatureFinish_DT"].ToString() != "") { model.SignatureFinish_DT = DateTime.Parse(row["SignatureFinish_DT"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL GetModel(int SignatureLogID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SignatureLogID,FileListID,SingleProjectID,Signature_DT,Signature_UserID,Signature_UserRoleCode,FileListTmpID,Message,OperationType,SignatureFinishFlag,SignatureFinish_DT from T_FileList_SignatureLog "); strSql.Append(" where SignatureLogID=@SignatureLogID "); SqlParameter[] parameters = { new SqlParameter("@SignatureLogID", SqlDbType.Int, 8) }; parameters[0].Value = SignatureLogID; DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL model = new DigiPower.Onlinecol.Standard.Model.T_FileList_SignatureLog_MDL(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }