c# 使用odbc连接access 遇到的问题。急急急在线等解决办法

lihui_life 2016-07-05 04:33:20

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