public int InsertRequestAccount(RequestAccountInfo oParam) { string sql = @"INSERT INTO Sys_RequestAccount ( Name,Account, DepartMent,Phone,MobilePhone,Email,Note ) VALUES ( @Name,@Account, @DepartMent,@Phone,@MobilePhone,@Email,@Note )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramName = new SqlParameter("@Name", SqlDbType.VarChar, 50); SqlParameter paramAccount = new SqlParameter("@Account", SqlDbType.VarChar, 50); SqlParameter paramDepartMent = new SqlParameter("@DepartMent", SqlDbType.VarChar, 100); SqlParameter paramPhone = new SqlParameter("@Phone", SqlDbType.VarChar, 50); SqlParameter paramMobilePhone = new SqlParameter("@MobilePhone", SqlDbType.VarChar, 50); SqlParameter paramEmail = new SqlParameter("@Email", SqlDbType.VarChar, 50); SqlParameter paramNote = new SqlParameter("@Note", SqlDbType.VarChar, 200); paramName.Value = oParam.Name; ; paramAccount.Value = oParam.Account; paramDepartMent.Value = oParam.DepartMent; if (oParam.Phone != AppConst.StringNull) paramPhone.Value = oParam.Phone; else paramPhone.Value = System.DBNull.Value; paramMobilePhone.Value = oParam.MobilePhone; paramEmail.Value = oParam.Email; if (oParam.Note != AppConst.StringNull) paramNote.Value = oParam.Note; else paramNote.Value = System.DBNull.Value; cmd.Parameters.Add(paramName); cmd.Parameters.Add(paramAccount); cmd.Parameters.Add(paramDepartMent); cmd.Parameters.Add(paramPhone); cmd.Parameters.Add(paramMobilePhone); cmd.Parameters.Add(paramEmail); cmd.Parameters.Add(paramNote); return SqlHelper.ExecuteNonQuery(cmd); }
/// <summary> /// �����������˻�����Ϣ /// </summary> /// <param name="oParam"></param> /// <returns></returns> public int InsertRequestAccount(RequestAccountInfo oParam) { return new UserDac().InsertRequestAccount(oParam); }