public static int AddressInfoAdd(string SPID, string CustID, AddressInfo Address, out long NewAddressID, out string ErrMsg) { int Result = ErrorDefinition.IError_Result_UnknowError_Code; ErrMsg = ErrorDefinition.BT_IError_Result_UnknowError_Msg; SqlConnection myCon = new SqlConnection(DBUtility.BestToneCenterConStr); SqlTransaction myTrans = null; try { myCon.Open(); myTrans = myCon.BeginTransaction(); SqlCommand cmd = new SqlCommand(); cmd.Connection = myTrans.Connection; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddressInfoAdd"; cmd.Transaction = myTrans; SqlParameter parSPID = new SqlParameter("@SPID", SqlDbType.VarChar, 8); parSPID.Value = SPID; cmd.Parameters.Add(parSPID); SqlParameter parCustID = new SqlParameter("@CustID", SqlDbType.VarChar, 16); parCustID.Value = CustID; cmd.Parameters.Add(parCustID); SqlParameter parNewAddressID = new SqlParameter("@NewAddressID", SqlDbType.BigInt, 8); parNewAddressID.Direction = ParameterDirection.Output; cmd.Parameters.Add(parNewAddressID); SqlParameter parAreaCode = new SqlParameter("@AreaCode", SqlDbType.VarChar, 6); parAreaCode.Value = Address.AreaCode == null ? "" : Address.AreaCode; cmd.Parameters.Add(parAreaCode); SqlParameter parAddress = new SqlParameter("@Address", SqlDbType.VarChar, 256); parAddress.Value = Address.Address == null ? "" : Address.Address; cmd.Parameters.Add(parAddress); SqlParameter parZipcode = new SqlParameter("@Zipcode", SqlDbType.VarChar, 6); parZipcode.Value = Address.Zipcode == null ? "" : Address.Zipcode; cmd.Parameters.Add(parZipcode); SqlParameter parType = new SqlParameter("@Type", SqlDbType.VarChar, 20); parType.Value = Address.Type == null ? "" : Address.Type; cmd.Parameters.Add(parType); SqlParameter parOtherType = new SqlParameter("@OtherType", SqlDbType.VarChar, 50); parOtherType.Value = Address.OtherType == null ? "" : Address.OtherType; cmd.Parameters.Add(parOtherType); SqlParameter parRelationPerson = new SqlParameter("@RelationPerson", SqlDbType.VarChar, 20); parRelationPerson.Value = Address.RelationPerson == null ? "" : Address.RelationPerson; cmd.Parameters.Add(parRelationPerson); SqlParameter parMobile = new SqlParameter("@Mobile", SqlDbType.VarChar, 20); parMobile.Value = Address.Mobile == null ? "" : Address.Mobile; cmd.Parameters.Add(parMobile); SqlParameter parFixedPhone = new SqlParameter("@FixedPhone", SqlDbType.VarChar, 20); parFixedPhone.Value = Address.FixedPhone == null ? "" : Address.FixedPhone; cmd.Parameters.Add(parFixedPhone); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int, 4); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); cmd.ExecuteNonQuery(); NewAddressID = int.Parse(parNewAddressID.Value.ToString().Trim()); Result = int.Parse(parResult.Value.ToString().Trim()); ErrMsg = parErrMsg.Value.ToString().Trim(); if (Result != 0) { myTrans.Rollback(); return Result; } myTrans.Commit(); } catch (Exception e) { if (myTrans != null) { myTrans.Rollback(); } NewAddressID = -1; Result = ErrorDefinition.BT_IError_Result_System_UnknowError_Code; ErrMsg = ErrorDefinition.BT_IError_Result_System_UnknowError_Msg + e.Message; } finally { if (myCon.State != ConnectionState.Closed) { myCon.Close(); } } return Result; }
public static AddressInfo AddressInfoLoad(string SPID, long AddressID, out int Result, out string ErrMsg) { AddressInfo Address = null; Result = ErrorDefinition.IError_Result_UnknowError_Code; ErrMsg = ErrorDefinition.BT_IError_Result_UnknowError_Msg; SqlConnection myCon = new SqlConnection(DBUtility.BestToneCenterConStr); try { SqlCommand cmd = new SqlCommand(); DataSet ds = null; cmd.Connection = myCon; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddressInfoLoad"; SqlParameter parSPID = new SqlParameter("@SPID", SqlDbType.VarChar, 8); parSPID.Value = SPID; cmd.Parameters.Add(parSPID); SqlParameter parAddressID = new SqlParameter("@AddressID", SqlDbType.BigInt, 8); parAddressID.Value = AddressID; cmd.Parameters.Add(parAddressID); SqlParameter parResult = new SqlParameter("@Result", SqlDbType.Int, 4); parResult.Direction = ParameterDirection.Output; cmd.Parameters.Add(parResult); SqlParameter parErrMsg = new SqlParameter("@ErrMsg", SqlDbType.VarChar, 256); parErrMsg.Direction = ParameterDirection.Output; cmd.Parameters.Add(parErrMsg); ds = DBUtility.FillData(cmd, DBUtility.BestToneCenterConStr); Result = int.Parse(parResult.Value.ToString().Trim()); ErrMsg = parErrMsg.Value.ToString().Trim(); if ( Result == 0 && ds != null ) { if (ds.Tables.Count != 0) { if (ds.Tables[0].Rows.Count != 0) { Address = new AddressInfo(); Address.AddressID = long.Parse(ds.Tables[0].Rows[0]["SequenceID"].ToString().Trim()); Address.AreaCode = ds.Tables[0].Rows[0]["AreaCode"].ToString().Trim(); Address.Address = ds.Tables[0].Rows[0]["Address"].ToString().Trim(); Address.Zipcode = ds.Tables[0].Rows[0]["ZipCode"].ToString().Trim(); Address.Type = ds.Tables[0].Rows[0]["Type"].ToString().Trim(); Address.OtherType = ds.Tables[0].Rows[0]["OtherType"].ToString().Trim(); Address.RelationPerson = ds.Tables[0].Rows[0]["RelationPerson"].ToString().Trim(); Address.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString().Trim(); Address.FixedPhone = ds.Tables[0].Rows[0]["FixedPhone"].ToString().Trim(); } } } } catch (Exception e) { Result = ErrorDefinition.IError_Result_System_UnknowError_Code; ErrMsg = "��ȡ�ͻ����õ�ַ��Ϣ�����" + e.Message; } return Address; }