public long Insert(Tz888.Model.Info.InfoDefaultDEFModel model)
{
int rowsAffected;
SqlParameter[] parameters = new SqlParameter[4];
parameters[0] = new SqlParameter("@ID", SqlDbType.BigInt);
parameters[0].Value = model.ID;
parameters[0].Direction = ParameterDirection.InputOutput;
parameters[1] = new SqlParameter("@InfoID", SqlDbType.BigInt);
parameters[1].Value = model.InfoID;
parameters[2] = new SqlParameter("@SubDefaultValueID", SqlDbType.BigInt);
parameters[2].Value = model.SubDefaultValueID;
parameters[3] = new SqlParameter("@DefType", SqlDbType.TinyInt);
parameters[3].Value = model.DefType;
DbHelperSQL.RunProcedure("InfoDefaultDEFTab_Insert", parameters, out rowsAffected);
return Convert.ToInt64(parameters[0].Value);
}
/// <summary>
/// 根据infoID,以及各CheckBoxList的值保存。
/// </summary>
/// <param name="infoID"></param>
/// <param name="chkKeyWord"></param>
/// <param name="chkTitles"></param>
/// <param name="chkDes"></param>
public static void SaveKeyWordTitleDes(long infoID, string[][] allDefaults, CheckBoxList chkKeyWord, bool keyworkDefault, CheckBoxList chkTitles, bool titleDefault, CheckBoxList chkDes, bool desDefault)
{
Tz888.BLL.Info.InfoDefaultDEFRule infoDefault = new InfoDefaultDEFRule();
infoDefault.DeSelect(infoID);//将这条信息的原有定义全部不选择
//保存关键字
if (keyworkDefault == false)
{
for (int i = 0; i < chkKeyWord.Items.Count; i++)
{
if (chkKeyWord.Items[i].Selected)
{
Tz888.Model.Info.InfoDefaultDEFModel model = new Tz888.Model.Info.InfoDefaultDEFModel();
model.InfoID = infoID;
model.DefType = 2;//关键字类型
model.IsSelect = 1;
model.SubDefaultValueID = Convert.ToInt64(chkKeyWord.Items[i].Value);
infoDefault.Insert(model);
}
}
}
else//使用默认关键字
{
//dvDefault.RowFilter = "(IsDefaultSelect =1 OR IsNeeded=1) AND (DefType=2 OR DefType=3 OR DefType=6 OR DefType=7) ";
for (int i = 0; i < allDefaults[0].Length; i++)
{
Tz888.Model.Info.InfoDefaultDEFModel model = new Tz888.Model.Info.InfoDefaultDEFModel();
model.InfoID = infoID;
model.DefType = 2;//关键字类型
model.IsSelect = 1;
model.SubDefaultValueID = Convert.ToInt64(allDefaults[0][i]);
infoDefault.Insert(model);
}
}
//保存标题定义
if (titleDefault == false)
{
for (int i = 0; i < chkTitles.Items.Count; i++)
{
if (chkTitles.Items[i].Selected)
{
Tz888.Model.Info.InfoDefaultDEFModel model = new Tz888.Model.Info.InfoDefaultDEFModel();
model.InfoID = infoID;
model.DefType = 1;//标题类型
model.IsSelect = 1;
model.SubDefaultValueID = Convert.ToInt64(chkTitles.Items[i].Value);
infoDefault.Insert(model);
}
}
}
else
{//标题默认设置
//dvDefault.RowFilter = "(IsDefaultSelect =1 OR IsNeeded=1) AND (DefType=1 OR DefType=3 OR DefType=5 OR DefType=7) ";
for (int i = 0; i < allDefaults[1].Length; i++)
{
Tz888.Model.Info.InfoDefaultDEFModel model = new Tz888.Model.Info.InfoDefaultDEFModel();
model.InfoID = infoID;
model.DefType = 1;//标题类型
model.IsSelect = 1;
model.SubDefaultValueID = Convert.ToInt64(allDefaults[0][i]);
infoDefault.Insert(model);
}
}
//保存描述
if (desDefault == false)
{
for (int i = 0; i < chkDes.Items.Count; i++)
{
if (chkDes.Items[i].Selected)
{
Tz888.Model.Info.InfoDefaultDEFModel model = new Tz888.Model.Info.InfoDefaultDEFModel();
model.InfoID = infoID;
model.DefType = 4;//描述类型
model.IsSelect = 1;
model.SubDefaultValueID = Convert.ToInt64(chkDes.Items[i].Value);
infoDefault.Insert(model);
}
}
}
else
{//描述默认设置
//dvDefault.RowFilter = "(IsDefaultSelect =1 OR IsNeeded=1) AND (DefType=4 OR DefType=5 OR DefType=6 OR DefType=7) ";
for (int i = 0; i < allDefaults[2].Length; i++)
{
Tz888.Model.Info.InfoDefaultDEFModel model = new Tz888.Model.Info.InfoDefaultDEFModel();
model.InfoID = infoID;
model.DefType = 4;//描述类型
model.IsSelect = 1;
model.SubDefaultValueID = Convert.ToInt64(allDefaults[2][i]);
infoDefault.Insert(model);
}
}
}
public long Insert(Tz888.Model.Info.InfoDefaultDEFModel model)
{
return(dal.Insert(model));
}
