public List <LogisticsEnterprise> LoadLogisticsEnterprisesByMobile(string mobile)
{
string sql = @"SELECT [EnterpriseID]
, [EnterpriseName]
, [Address]
, [LinkMan]
, [Mobile]
, [Tel]
, [Created]
, [CreatedBy]
, [Modified]
, [ModifiedBy]
FROM [BE_LogisticsEnterprise] WHERE [Mobile]=@Mobile" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pMobile = new SqlParameter("Mobile", mobile);
pMobile.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMobile);
List <LogisticsEnterprise> ret = new List <LogisticsEnterprise>();
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
LogisticsEnterprise iret = new LogisticsEnterprise();
if (!Convert.IsDBNull(dr["EnterpriseID"]))
{
iret.EnterpriseID = (Guid)dr["EnterpriseID"];
}
iret.EnterpriseName = dr["EnterpriseName"].ToString();
iret.Address = dr["Address"].ToString();
iret.LinkMan = dr["LinkMan"].ToString();
iret.Mobile = dr["Mobile"].ToString();
iret.Tel = dr["Tel"].ToString();
if (!Convert.IsDBNull(dr["Created"]))
{
iret.Created = (DateTime)dr["Created"];
}
iret.CreatedBy = dr["CreatedBy"].ToString();
if (!Convert.IsDBNull(dr["Modified"]))
{
iret.Modified = (DateTime)dr["Modified"];
}
iret.ModifiedBy = dr["ModifiedBy"].ToString();
ret.Add(iret);
}
}
finally
{
dr.Close();
}
return(ret);
}
public int LoadLogisticsEnterpriseByEnterpriseID(LogisticsEnterprise obj)
{
string sql = @"SELECT [EnterpriseID]
, [EnterpriseName]
, [Address]
, [LinkMan]
, [Mobile]
, [Tel]
, [Created]
, [CreatedBy]
, [Modified]
, [ModifiedBy]
FROM [BE_LogisticsEnterprise] WITH(NOLOCK) WHERE [EnterpriseID]=@EnterpriseID" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pEnterpriseID = new SqlParameter("EnterpriseID", Convert2DBnull(obj.EnterpriseID));
pEnterpriseID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pEnterpriseID);
int ret = 0;
SqlDataReader dr = cmd.ExecuteReader();
try
{
while (dr.Read())
{
if (!Convert.IsDBNull(dr["EnterpriseID"]))
{
obj.EnterpriseID = (Guid)dr["EnterpriseID"];
}
obj.EnterpriseName = dr["EnterpriseName"].ToString();
obj.Address = dr["Address"].ToString();
obj.LinkMan = dr["LinkMan"].ToString();
obj.Mobile = dr["Mobile"].ToString();
obj.Tel = dr["Tel"].ToString();
if (!Convert.IsDBNull(dr["Created"]))
{
obj.Created = (DateTime)dr["Created"];
}
obj.CreatedBy = dr["CreatedBy"].ToString();
if (!Convert.IsDBNull(dr["Modified"]))
{
obj.Modified = (DateTime)dr["Modified"];
}
obj.ModifiedBy = dr["ModifiedBy"].ToString();
ret += 1;
}
}
finally
{
dr.Close();
}
return(ret);
}
public int UpdateLogisticsEnterpriseByEnterpriseID(LogisticsEnterprise obj)
{
string sql = @"UPDATE [BE_LogisticsEnterprise] SET [EnterpriseName]=@EnterpriseName
, [Address]=@Address
, [LinkMan]=@LinkMan
, [Mobile]=@Mobile
, [Tel]=@Tel
, [Created]=@Created
, [CreatedBy]=@CreatedBy
, [Modified]=@Modified
, [ModifiedBy]=@ModifiedBy
WHERE [EnterpriseID]=@EnterpriseID" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pEnterpriseName = new SqlParameter("EnterpriseName", Convert2DBnull(obj.EnterpriseName));
pEnterpriseName.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pEnterpriseName);
SqlParameter pAddress = new SqlParameter("Address", Convert2DBnull(obj.Address));
pAddress.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pAddress);
SqlParameter pLinkMan = new SqlParameter("LinkMan", Convert2DBnull(obj.LinkMan));
pLinkMan.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pLinkMan);
SqlParameter pMobile = new SqlParameter("Mobile", Convert2DBnull(obj.Mobile));
pMobile.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMobile);
SqlParameter pTel = new SqlParameter("Tel", Convert2DBnull(obj.Tel));
pTel.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pTel);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
SqlParameter pModified = new SqlParameter("Modified", Convert2DBnull(obj.Modified));
pModified.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pModified);
SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", Convert2DBnull(obj.ModifiedBy));
pModifiedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pModifiedBy);
SqlParameter pEnterpriseID = new SqlParameter("EnterpriseID", Convert2DBnull(obj.EnterpriseID));
pEnterpriseID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pEnterpriseID);
return(cmd.ExecuteNonQuery());
}
public int InsertLogisticsEnterprise(LogisticsEnterprise obj)
{
string sql = @"INSERT INTO[BE_LogisticsEnterprise]([EnterpriseID]
, [EnterpriseName]
, [Address]
, [LinkMan]
, [Mobile]
, [Tel]
, [Created]
, [CreatedBy]
, [Modified]
, [ModifiedBy]
) VALUES(@EnterpriseID
, @EnterpriseName
, @Address
, @LinkMan
, @Mobile
, @Tel
, @Created
, @CreatedBy
, @Modified
, @ModifiedBy
)" ;
SqlCommand cmd = new SqlCommand(sql, this.conn, this.trans);
SqlParameter pEnterpriseID = new SqlParameter("EnterpriseID", Convert2DBnull(obj.EnterpriseID));
pEnterpriseID.SqlDbType = SqlDbType.UniqueIdentifier;
cmd.Parameters.Add(pEnterpriseID);
SqlParameter pEnterpriseName = new SqlParameter("EnterpriseName", Convert2DBnull(obj.EnterpriseName));
pEnterpriseName.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pEnterpriseName);
SqlParameter pAddress = new SqlParameter("Address", Convert2DBnull(obj.Address));
pAddress.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pAddress);
SqlParameter pLinkMan = new SqlParameter("LinkMan", Convert2DBnull(obj.LinkMan));
pLinkMan.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pLinkMan);
SqlParameter pMobile = new SqlParameter("Mobile", Convert2DBnull(obj.Mobile));
pMobile.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pMobile);
SqlParameter pTel = new SqlParameter("Tel", Convert2DBnull(obj.Tel));
pTel.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pTel);
SqlParameter pCreated = new SqlParameter("Created", Convert2DBnull(obj.Created));
pCreated.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pCreated);
SqlParameter pCreatedBy = new SqlParameter("CreatedBy", Convert2DBnull(obj.CreatedBy));
pCreatedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pCreatedBy);
SqlParameter pModified = new SqlParameter("Modified", Convert2DBnull(obj.Modified));
pModified.SqlDbType = SqlDbType.DateTime;
cmd.Parameters.Add(pModified);
SqlParameter pModifiedBy = new SqlParameter("ModifiedBy", Convert2DBnull(obj.ModifiedBy));
pModifiedBy.SqlDbType = SqlDbType.NVarChar;
cmd.Parameters.Add(pModifiedBy);
return(cmd.ExecuteNonQuery());
}
