public void AgencyAdd(Tz888.Model.Register.SS_Agency_Services model)
{
SqlParameter[] parameters =
{
new SqlParameter("@LoginName", SqlDbType.Char, 16),
new SqlParameter("@OrganName", SqlDbType.VarChar, 50),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Int),
new SqlParameter("@CityID", SqlDbType.Int),
new SqlParameter("@Area", SqlDbType.Int),
new SqlParameter("@OrganType", SqlDbType.Int),
new SqlParameter("@ServiceBigtype", SqlDbType.Int),
new SqlParameter("@ServiceSmalltype", SqlDbType.VarChar, 100),
new SqlParameter("@BusinessCount", SqlDbType.Int),
new SqlParameter("@Bankroll", SqlDbType.Int),
new SqlParameter("@FoundDate", SqlDbType.VarChar, 30),
new SqlParameter("@Turnover", SqlDbType.VarChar, 50),
new SqlParameter("@BusinessView", SqlDbType.VarChar, 200),
new SqlParameter("@www", SqlDbType.VarChar, 50),
new SqlParameter("@LinkName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@FAX", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@Regdate", SqlDbType.DateTime)
};
parameters[0].Value = model.LoginName;
parameters[1].Value = model.OrganName;
parameters[2].Value = model.CountryCode;
parameters[3].Value = model.ProvinceID;
parameters[4].Value = model.CityID;
parameters[5].Value = model.Area;
parameters[6].Value = model.OrganType;
parameters[7].Value = model.ServiceBigtype;
parameters[8].Value = model.ServiceSmalltype;
parameters[9].Value = model.BusinessCount;
parameters[10].Value = model.Bankroll;
parameters[11].Value = model.FoundDate;
parameters[12].Value = model.Turnover;
parameters[13].Value = model.BusinessView;
parameters[14].Value = model.www;
parameters[15].Value = model.LinkName;
parameters[16].Value = model.Tel;
parameters[17].Value = model.FAX;
parameters[18].Value = model.Email;
parameters[19].Value = model.Regdate;
try
{
DbHelperSQL.RunProcLob("StructInsert", parameters);
}
catch (SqlException ex)
{
throw new Exception(ex.Message);
}
// DbHelperSQL.RunProcedure(
}
public bool SS_StrUpdate(Tz888.Model.Register.SS_Agency_Services model)
{
SqlParameter[] parameters =
{
new SqlParameter("@OrganID", SqlDbType.Int),
new SqlParameter("@OrganName", SqlDbType.VarChar, 50),
new SqlParameter("@CountryCode", SqlDbType.Char, 10),
new SqlParameter("@ProvinceID", SqlDbType.Int),
new SqlParameter("@CityID", SqlDbType.Int),
new SqlParameter("@Area", SqlDbType.Int),
new SqlParameter("@OrganType", SqlDbType.Int),
new SqlParameter("@ServiceBigtype", SqlDbType.Int),
new SqlParameter("@ServiceSmalltype", SqlDbType.VarChar, 100),
new SqlParameter("@BusinessCount", SqlDbType.Int),
new SqlParameter("@Bankroll", SqlDbType.Int),
new SqlParameter("@FoundDate", SqlDbType.VarChar, 30),
new SqlParameter("@Turnover", SqlDbType.VarChar, 50),
new SqlParameter("@BusinessView", SqlDbType.VarChar, 200),
new SqlParameter("@www", SqlDbType.VarChar, 50),
new SqlParameter("@LinkName", SqlDbType.VarChar, 50),
new SqlParameter("@Tel", SqlDbType.VarChar, 50),
new SqlParameter("@FAX", SqlDbType.VarChar, 50),
new SqlParameter("@Email", SqlDbType.VarChar, 50),
new SqlParameter("@flag", SqlDbType.VarChar, 50),
};
parameters[0].Value = model.OrganID;
parameters[1].Value = model.OrganName;
parameters[2].Value = model.CountryCode;
parameters[3].Value = model.ProvinceID;
parameters[4].Value = model.CityID;
parameters[5].Value = model.Area;
parameters[6].Value = model.OrganType;
parameters[7].Value = model.ServiceBigtype;
parameters[8].Value = model.ServiceSmalltype;
parameters[9].Value = model.BusinessCount;
parameters[10].Value = model.Bankroll;
parameters[11].Value = model.FoundDate;
parameters[12].Value = model.Turnover;
parameters[13].Value = model.BusinessView;
parameters[14].Value = model.www;
parameters[15].Value = model.LinkName;
parameters[16].Value = model.Tel;
parameters[17].Value = model.FAX;
parameters[18].Value = model.Email;
parameters[19].Value = "update";
return(DbHelperSQL.RunProcLob("StructInsert", parameters));
}
public Tz888.Model.Register.SS_Agency_Services getModel(string FileName, string TableName, string Where, int Top)
{
SqlParameter[] parameters =
{
new SqlParameter("@FileName", SqlDbType.VarChar, 300),
new SqlParameter("@TableName", SqlDbType.VarChar, 100),
new SqlParameter("@Where", SqlDbType.VarChar, 300),
new SqlParameter("@Top", SqlDbType.Int),
};
parameters[0].Value = FileName;
parameters[1].Value = TableName;
parameters[2].Value = Where;
parameters[3].Value = Top;
DataSet ds = DbHelperSQL.RunProcedure("Common_Top", parameters, "SS_Str");
Tz888.Model.Register.SS_Agency_Services model = new Tz888.Model.Register.SS_Agency_Services();
if (ds != null)
{
DataTable dt = ds.Tables["SS_Str"];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
model.LoginName = dt.Rows[0]["LoginName"].ToString();
model.OrganName = dt.Rows[0]["OrganName"].ToString();
model.CountryCode = dt.Rows[0]["CountryCode"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["ProvinceID"].ToString()))
{
model.ProvinceID = int.Parse(dt.Rows[0]["ProvinceID"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["CityID"].ToString()))
{
model.CityID = int.Parse(dt.Rows[0]["CityID"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Area"].ToString()))
{
model.Area = int.Parse(dt.Rows[0]["Area"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["OrganType"].ToString()))
{
model.OrganType = int.Parse(dt.Rows[0]["OrganType"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["ServiceBigtype"].ToString()))
{
model.ServiceBigtype = int.Parse(dt.Rows[0]["ServiceBigtype"].ToString());
}
model.ServiceSmalltype = dt.Rows[0]["ServiceSmalltype"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["BusinessCount"].ToString()))
{
model.BusinessCount = int.Parse(dt.Rows[0]["BusinessCount"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["Bankroll"].ToString()))
{
model.Bankroll = int.Parse(dt.Rows[0]["Bankroll"].ToString());
}
model.FoundDate = dt.Rows[0]["FoundDate"].ToString();
model.Turnover = dt.Rows[0]["Turnover"].ToString();
model.BusinessView = dt.Rows[0]["BusinessView"].ToString();
model.www = dt.Rows[0]["www"].ToString();
model.LinkName = dt.Rows[0]["LinkName"].ToString();
model.Tel = dt.Rows[0]["Tel"].ToString();
model.FAX = dt.Rows[0]["FAX"].ToString();
model.Email = dt.Rows[0]["Email"].ToString();
if (!string.IsNullOrEmpty(dt.Rows[0]["Regdate"].ToString()))
{
model.Regdate = DateTime.Parse(dt.Rows[0]["Regdate"].ToString());
}
if (!string.IsNullOrEmpty(dt.Rows[0]["IsChekUp"].ToString()))
{
model.IsChekUp = int.Parse(dt.Rows[0]["IsChekUp"].ToString());
}
}
}
}
return(model);
}
public bool SS_StrUpdate(Tz888.Model.Register.SS_Agency_Services model)
{
return(mode.SS_StrUpdate(model));
}
// 会员注册
public void AgencyAdd(Tz888.Model.Register.SS_Agency_Services model)
{
mode.AgencyAdd(model);
}
