public SupplierInfo DataRowToModel(DataRow row)
{
SupplierInfo model = new Model.SupplierInfo();
if (row != null)
{
if (row["SId"].ToString() != "")
{
model.SId = int.Parse(row["SId"].ToString());
}
model.CompanyWebsite = row["CompanyWebsite"].ToString();
model.CompanyPhone = row["CompanyPhone"].ToString();
model.CautionMoney = row["CautionMoney"].ToString();
model.Guarantee = row["Guarantee"].ToString();
model.GuaranteeMobile = row["GuaranteeMobile"].ToString();
model.Balance = row["Balance"].ToString();
model.LockBalance = row["LockBalance"].ToString();
model.TotalBalance = row["TotalBalance"].ToString();
if (row["Type"].ToString() != "")
{
model.Type = int.Parse(row["Type"].ToString());
}
if (row["State"].ToString() != "")
{
model.State = int.Parse(row["State"].ToString());
}
model.SignName = row["SignName"].ToString();
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["UpdateTime"].ToString() != "")
{
model.UpdateTime = DateTime.Parse(row["UpdateTime"].ToString());
}
model.Remark = row["Remark"].ToString();
model.extend1 = row["extend1"].ToString();
model.extend2 = row["extend2"].ToString();
model.extend3 = row["extend3"].ToString();
model.extend4 = row["extend4"].ToString();
model.extend5 = row["extend5"].ToString();
model.UserName = row["UserName"].ToString();
model.UserMobile = row["UserMobile"].ToString();
model.UserEmail = row["UserEmail"].ToString();
model.UserAdress = row["UserAdress"].ToString();
if (row["UserQQ"].ToString() != "")
{
model.UserQQ = row["UserQQ"].ToString();
}
model.UserWechat = row["UserWechat"].ToString();
model.CorporateName = row["CorporateName"].ToString();
return(model);
}
else
{
return(null);
}
}
public JsonResult addupd(Model.SupplierInfo supplier)
{
string strResult = "FAIL";
if (supplier.SupplierName != null)
{
MoyeBuy.Com.BLL.Supplier bsupplier = new BLL.Supplier();
if (bsupplier.AddUpdateProductSupplier(supplier))
{
strResult = "SUCCESS";
}
}
return(Json(strResult));
}
private Model.SupplierInfo GetSupplierInfo(DataRow dr)
{
if (dr == null)
{
return(null);
}
Model.SupplierInfo si = new Model.SupplierInfo();
si.SupplierInfoOID = Convert.ToInt32(dr["SupplierInfoOID"]);
si.SupplierCode = Convert.ToString(dr["SupplierCode"]);
si.SupplierName = Convert.ToString(dr["SupplierName"]);
si.TaxID = Convert.ToString(dr["TaxID"]);
si.Email = Convert.ToString(dr["Email"]);
si.Tel = Convert.ToString(dr["Tel"]);
si.Address = Convert.ToString(dr["Address"]);
si.SupplierRatingOID = Convert.ToInt32(dr["SupplierRatingOID"]);
return(si);
}
public Model.SupplierInfo FindSupplierInfoBySupplierCode(string SupplierCode)
{
string strCmd = @"select SupplierInfoOID, SupplierCode, SupplierName,
TaxID, Email, Tel, [Address], SupplierRatingOID
from dbo.SupplierInfo
where SupplierCode = @SupplierCode";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(SqlHelper.CreateParameter("@SupplierCode", SqlDbType.NVarChar, 6, SupplierCode));
DataTable dt = SqlHelper.AdapterFill(strCmd, parameters);
if (dt.Rows.Count == 0)
{
return(null);
}
Model.SupplierInfo si = this.GetSupplierInfo(dt.Rows[0]);
return(si);
}
public bool AddUpdateProductSupplier(Model.SupplierInfo supplier)
{
return(dal.AddUpdateSupplier(supplier));
}
