protected void btnSubmit_Click(object sender, EventArgs e)
{
int numLength = ADeeWu.HuoBi3J.Libary.Utility.GetInt(this.txtNumLength.Text, 0);
int startNum = ADeeWu.HuoBi3J.Libary.Utility.GetInt(this.txtStartNum.Text, 0);
if (numLength < 1)
{
ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("通讯号码长度输入不正确!");
return;
}
if (startNum < 1)
{
ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("通讯号码起始数输入不正确!");
return;
}
List<ADeeWu.HuoBi3J.Model.IM_UINS> dataSource = new List<ADeeWu.HuoBi3J.Model.IM_UINS>();
for (int i = 0; i < numLength; i++)
{
ADeeWu.HuoBi3J.Model.IM_UINS model = new ADeeWu.HuoBi3J.Model.IM_UINS();
model.CreateTime = DateTime.Now;
model.HasUsed = false;
model.IsRecommend = false;
model.Sequence = 0;
model.UIN = GetSerialNum(ref startNum).ToString();
dal.Add(model);
dataSource.Add(model);
}
ADeeWu.HuoBi3J.Libary.WebUtility.ShowMsg("生成成功,请查看结果!");
this.gvData.DataSource = (IList<ADeeWu.HuoBi3J.Model.IM_UINS>)dataSource;
this.gvData.DataBind();
}
public ADeeWu.HuoBi3J.Model.IM_UINS[] GetEntityList(string orderBy,string[] columns,params object[] values)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from [IM_UINS] where 1=1");
db.Parameters.Clear();
for(int i=0;i<columns.Length;i++)
{
builder.AppendFormat(" and [{0}]=@{0}", columns[i]);
db.Parameters.Append("@"+columns[i],values[i]);
}
if (!string.IsNullOrEmpty(orderBy))
{
builder.AppendFormat(" order by {0}", orderBy);
}
DataTable dt = db.Select(builder.ToString());
ADeeWu.HuoBi3J.Model.IM_UINS[] EntityList = new ADeeWu.HuoBi3J.Model.IM_UINS[dt.Rows.Count];
if (dt.Rows.Count == 0) return EntityList;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
ADeeWu.HuoBi3J.Model.IM_UINS Entity = new ADeeWu.HuoBi3J.Model.IM_UINS();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.HasUsed = bool.Parse(dr["HasUsed"].ToString());
Entity.IsRecommend = bool.Parse(dr["IsRecommend"].ToString());
Entity.Sequence = int.Parse(dr["Sequence"].ToString());
Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
EntityList[i] = Entity;
}
return EntityList;
}
public ADeeWu.HuoBi3J.Model.IM_UINS GetEntity(string where)
{
DataTable dt = this.Select(where,"");
if(dt.Rows.Count==0) return null;
DataRow dr = dt.Rows[0];
ADeeWu.HuoBi3J.Model.IM_UINS Entity = new ADeeWu.HuoBi3J.Model.IM_UINS();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.HasUsed = bool.Parse(dr["HasUsed"].ToString());
Entity.IsRecommend = bool.Parse(dr["IsRecommend"].ToString());
Entity.Sequence = int.Parse(dr["Sequence"].ToString());
Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
return Entity;
}
public ADeeWu.HuoBi3J.Model.IM_UINS GetEntity(long ID)
{
db.Parameters.Clear();
db.Parameters.Append("@ID",ID);
DataTable dt = db.Select("select * from [IM_UINS] where 1=1 and [ID]=@ID");
if(dt.Rows.Count==0) return null;
DataRow dr = dt.Rows[0];
ADeeWu.HuoBi3J.Model.IM_UINS Entity = new ADeeWu.HuoBi3J.Model.IM_UINS();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.HasUsed = bool.Parse(dr["HasUsed"].ToString());
Entity.IsRecommend = bool.Parse(dr["IsRecommend"].ToString());
Entity.Sequence = int.Parse(dr["Sequence"].ToString());
Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
return Entity;
}
