public static int InsertUserAptitude(UserAptitude Uap, byte[] fileByte, ref string a_strErr) { int intInsert = 0; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@fileByte", fileByte) }; SQLTrans sqlTrans = new SQLTrans(); sqlTrans.Open("SupplyCnn"); //string strInsert = GSqlSentence.GetInsertInfoByD<UserAptitude>(Uaptitude, "tk_UserAptitude"); string strInsert = "insert into tk_UserAptitude (UserID,UserName,BusinessType,TecoName,TecoClass,GetTime,CertificatCode,CertificateName," + "CertificateUnit,LastCertificatDate,CertificatDate,FileName,FileInfo,Remark,Unit,State,CreateTime,CreateUser,Validate) values (" + "'" + Uap.StrUserID + "','" + Uap.StrUserName + "','" + Uap.StrBusinessType + "','" + Uap.StrTecoName + "','" + Uap.StrTecoClass + "','" + Uap.StrGetTime + "'," + "'" + Uap.StrCertificatCode + "','" + Uap.StrCertificateName + "','" + Uap.StrCertificateUnit + "','" + Uap.StrLastCertificatDate + "','" + Uap.StrCertificatDate + "'," + "'" + Uap.StrFileName + "',@fileByte,'" + Uap.StrRemark + "','" + Uap.StrUnit + "','" + Uap.StrState + "','" + Uap.StrCreateTime + "','" + Uap.StrCreateUser + "','" + Uap.StrValidate + "')"; try { if (strInsert != "") { intInsert = sqlTrans.ExecuteNonQuery(strInsert, CommandType.Text, para); } sqlTrans.Close(true); } catch (SqlException e) { sqlTrans.Close(false); a_strErr = e.Message; return(-1); } return(intInsert); }
public static int UpdateUserAptitude(string ID, UserAptitude Uap, byte[] fileByte, ref string a_strErr) { int intInsert = 0; int intUpdate = 0; int intInsertHis = 0; SqlParameter[] para = new SqlParameter[] { new SqlParameter("@fileByte", fileByte) }; SQLTrans sqlTrans = new SQLTrans(); sqlTrans.Open("SupplyCnn"); string strInsertHis = "insert into tk_UserAptitudeHis (UserID,UserName,BusinessType,TecoName,TecoClass,GetTime,CertificatCode,CertificateName,CertificateUnit," + "LastCertificatDate,CertificatDate,FileName,FileInfo,Remark,Unit,State,CreateTime,CreateUser,Validate" + ") select UserID,UserName,BusinessType,TecoName,TecoClass,GetTime,CertificatCode,CertificateName,CertificateUnit,LastCertificatDate," + "CertificatDate,FileName,FileInfo,Remark,Unit,State,CreateTime,CreateUser,Validate from tk_UserAptitude where ID = '" + ID + "'"; string strInsert = "update tk_UserAptitude set BusinessType = '" + Uap.StrBusinessType + "',TecoName = '" + Uap.StrTecoName + "',TecoClass = '" + Uap.StrTecoClass + "'," + "GetTime = '" + Uap.StrGetTime + "',CertificatCode = '" + Uap.StrCertificatCode + "',CertificateName = '" + Uap.StrCertificateName + "',CertificateUnit = '" + Uap.StrCertificateUnit + "'," + "LastCertificatDate = '" + Uap.StrLastCertificatDate + "',CertificatDate = '" + Uap.StrCertificatDate + "',Remark = '" + Uap.StrRemark + "' where ID = '" + ID + "'"; string strUpdate = ""; if (Uap.StrFileName != null) { strUpdate = "update tk_UserAptitude set FileName = '" + Uap.StrFileName + "',FileInfo = @fileByte where ID = '" + ID + "'"; } try { if (strInsertHis != "") { intInsertHis = sqlTrans.ExecuteNonQuery(strInsertHis, CommandType.Text, null); } if (strInsert != "") { intInsert = sqlTrans.ExecuteNonQuery(strInsert, CommandType.Text, null); } if (strUpdate != "") { intUpdate = sqlTrans.ExecuteNonQuery(strUpdate, CommandType.Text, para); } sqlTrans.Close(true); } catch (SqlException e) { sqlTrans.Close(false); a_strErr = e.Message; return(-1); } return(intInsert); }
public static bool UpdateNewUserAptitude(string ID, UserAptitude Uap, byte[] fileByte, ref string a_strErr) { if (UserAptitudePro.UpdateUserAptitude(ID, Uap, fileByte, ref a_strErr) >= 1) { return(true); } else { return(false); } }
public static bool InsertNewUserAptitude(UserAptitude Uaptitude, byte[] fileByte, ref string a_strErr) { if (UserAptitudePro.InsertUserAptitude(Uaptitude, fileByte, ref a_strErr) >= 1) { return(true); } else { return(false); } }
public static UserAptitude getUpdateUserAptitude(string id) { UserAptitude Uap = new UserAptitude(); string strSql = "select * from tk_UserAptitude where ID = '" + id + "'"; DataTable dt = SQLBase.FillTable(strSql, "SupplyCnn"); if (dt.Rows.Count > 0) { Uap.StrUserID = dt.Rows[0]["UserID"].ToString(); Uap.StrUserName = dt.Rows[0]["UserName"].ToString(); Uap.StrBusinessType = dt.Rows[0]["BusinessType"].ToString(); Uap.StrTecoName = dt.Rows[0]["TecoName"].ToString(); Uap.StrTecoClass = dt.Rows[0]["TecoClass"].ToString(); Uap.StrGetTime = Convert.ToDateTime(dt.Rows[0]["GetTime"]).ToString("yyyy-MM-dd"); Uap.StrCertificatCode = dt.Rows[0]["CertificatCode"].ToString(); Uap.StrCertificateName = dt.Rows[0]["CertificateName"].ToString(); Uap.StrCertificateUnit = dt.Rows[0]["CertificateUnit"].ToString(); Uap.StrLastCertificatDate = Convert.ToDateTime(dt.Rows[0]["LastCertificatDate"]).ToString("yyyy-MM-dd"); Uap.StrCertificatDate = Convert.ToDateTime(dt.Rows[0]["CertificatDate"]).ToString("yyyy-MM-dd"); Uap.StrFileName = dt.Rows[0]["FileName"].ToString(); Uap.StrRemark = dt.Rows[0]["Remark"].ToString(); } return(Uap); }