110,534
社区成员
发帖
与我相关
我的任务
分享
string sql = string.Format(@"UPDATE t_guest SET GUESTTYPE='{0}',GROUPID='{1}',
[NAME]='{2}',SEX='{3}',BIRTHDAY='{4}',IDTYPE='{5}',IDCODE='{6}',DISTRICTID='{7}',
[ADDRESS]='{8}',HOTELID='{9}',ROOMID='{10}',LTIME='{11}',LWAITER='{12}',ETIME='{13}',
EWAITER='{14}',PHOTO=?,FIRSTNAME='{15}',LASTNAME='{16}',
COUNTRY='{17}',NATION='{18}',SUMMARY='{19}',CREATETIME='{20}',
SCANTIME='{21}' WHERE GUESTID='{22}' ", guestType, groupId, model.ID_Name,
model.ID_Sex == "男" ? "1" : "2", model.ID_Birth.Replace("-", ""), idType,
model.ID_ID, districtId, model.ID_Addr, hotelId, model.Sign_RoomID, model.Oper_Date.ToString("yyyyMMddHHmm")
, string.IsNullOrEmpty(model.Oper_ID) ? "admin" : model.Oper_ID, "", "", "", "", country, nation,
sumMary, DateTime.Now.ToString("yyyyMMddHHmm"), DateTime.Now.ToString("yyyyMMddHHmm"), guestId);
System.Data.Odbc.OdbcParameter[] parm ={
// DBhelperForODBC.GetParameter("@GUESTTYPE",OdbcType.VarChar,guestType),
// DBhelperForODBC.GetParameter("@GROUPID",OdbcType.VarChar,groupId),
// DBhelperForODBC.GetParameter("@NAME",OdbcType.VarChar,model.ID_Name),
// DBhelperForODBC.GetParameter("@SEX",OdbcType.VarChar,model.ID_Sex=="男" ? "1" : "2"),
// DBhelperForODBC.GetParameter("@BIRTHDAY",OdbcType.VarChar,model.ID_Birth.Replace("-","")),
// DBhelperForODBC.GetParameter("@IDTYPE",OdbcType.VarChar,idType),
// DBhelperForODBC.GetParameter("@IDCODE",OdbcType.VarChar,model.ID_ID),
// DBhelperForODBC.GetParameter("@DISTRICTID",OdbcType.VarChar,districtId),
// DBhelperForODBC.GetParameter("@ADDRESS",OdbcType.VarChar,model.ID_Addr),
// DBhelperForODBC.GetParameter("@HOTELID",OdbcType.VarChar,hotelId),
// DBhelperForODBC.GetParameter("@ROOMID",OdbcType.VarChar,model.Sign_RoomID),
// DBhelperForODBC.GetParameter("@LTIME",OdbcType.VarChar,model.Oper_Date.ToString("yyyyMMddHHmm")),
// DBhelperForODBC.GetParameter("@LWAITER",OdbcType.VarChar,string.IsNullOrEmpty( model.Oper_ID) ? "admin" : model.Oper_ID),
// DBhelperForODBC.GetParameter("@ETIME",OdbcType.VarChar,""),
// DBhelperForODBC.GetParameter("@EWAITER",OdbcType.VarChar,""),
new OdbcParameter("@PHOTO",OdbcType.Binary,100000),
// DBhelperForODBC.GetParameter("@PHOTO",OdbcType.Binary,model.ID_Bmp),
// DBhelperForODBC.GetParameter("@FIRSTNAME",OdbcType.VarChar,""),
// DBhelperForODBC.GetParameter("@LASTNAME",OdbcType.VarChar,""),
// DBhelperForODBC.GetParameter("@COUNTRY",OdbcType.VarChar,country),
// DBhelperForODBC.GetParameter("@NATION",OdbcType.VarChar,nation),
// DBhelperForODBC.GetParameter("@SUMMARY",OdbcType.VarChar,sumMary),
// DBhelperForODBC.GetParameter("@CREATETIME",OdbcType.VarChar,DateTime.Now.ToString("yyyyMMddHHmm")),
// DBhelperForODBC.GetParameter("@SCANTIME",OdbcType.VarChar,DateTime.Now.ToString("yyyyMMddHHmm")),
// DBhelperForODBC.GetParameter("@GUESTID",OdbcType.VarChar,guestId)
};
DBhelperForODBC.ExecuteSql(sql, parm);