/// <summary>
/// ��������Model��
/// </summary>
public string CreatModelMethodT()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine(CreatModelMethod());
strclass.AppendSpaceLine(2, "private List<" + ModelNameSon + "> _" + ModelNameSon.ToLower() + "s;");//˽�б���
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// ���� ");
strclass.AppendSpaceLine(2, "/// </summary>");
//strclass.AppendSpaceLine(2, "[Serializable]");
strclass.AppendSpaceLine(2, "public List<" + ModelNameSon + "> " + ModelNameSon + "s");//����
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "set{" + " _" + ModelNameSon.ToLower() + "s=value;}");
strclass.AppendSpaceLine(3, "get{return " + "_" + ModelNameSon.ToLower() + "s;}");
strclass.AppendSpaceLine(2, "}");
return strclass.ToString();
}
protected override void OnLoad(EventArgs e)
{
InitValidationRules();
this.ParentForm.AcceptButton = btnLogin;
this.ParentForm.CancelButton = btnCancel;
this.ParentForm.FormClosing += ParentForm_FormClosing;
string uidmd5 = StringPlus.DecompressString(ConfigHelper.GetConfigString("u"));
string pwdmd5 = StringPlus.DecompressString(ConfigHelper.GetConfigString("p"));
if (string.IsNullOrWhiteSpace(uidmd5) || string.IsNullOrWhiteSpace(pwdmd5))
{
chkAutoLogin.Checked = false;
}
else
{
chkAutoLogin.Checked = true;
txtUid.EditValue = DESEncrypt.Decrypt(uidmd5);
txtPwd.EditValue = DESEncrypt.Decrypt(pwdmd5);
btnLogin_Click(btnLogin, e);
}
base.OnLoad(e);
}
public string CreatPROCGetMaxID()
{
StringPlus stringPlus = new StringPlus();
if (this._keys.Count > 0)
{
foreach (ColumnInfo current in this._keys)
{
if (CodeCommon.DbTypeToCS(current.TypeName) == "int")
{
string columnName = current.ColumnName;
if (current.IsPrimaryKey)
{
stringPlus.AppendLine("------------------------------------");
stringPlus.AppendLine("--用途：得到主键字段最大值 ");
stringPlus.AppendLine("--项目名称：" + this.ProjectName);
stringPlus.AppendLine("--说明：");
stringPlus.AppendLine("--时间：" + DateTime.Now.ToString());
stringPlus.AppendLine("------------------------------------");
stringPlus.AppendLine("CREATE PROCEDURE " + this.ProcPrefix + this._tablename + "_GetMaxId");
stringPlus.AppendLine("AS");
stringPlus.AppendSpaceLine(1, "DECLARE @TempID int");
stringPlus.AppendSpaceLine(1, "SELECT @TempID = max([" + columnName + "])+1 FROM " + this._tablename);
stringPlus.AppendSpaceLine(1, "IF @TempID IS NULL");
stringPlus.AppendSpaceLine(2, "RETURN 1");
stringPlus.AppendSpaceLine(1, "ELSE");
stringPlus.AppendSpaceLine(2, "RETURN @TempID");
stringPlus.AppendLine("");
stringPlus.AppendLine("GO");
break;
}
}
}
}
return(stringPlus.ToString());
}
public string GetWebCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm)
{
StringPlus stringPlus = new StringPlus();
if (AddForm)
{
stringPlus.AppendLine(" /******************************增加窗体代码********************************/");
stringPlus.AppendLine(this.GetAddAspxCs());
}
if (UpdateForm)
{
stringPlus.AppendLine(" /******************************修改窗体代码********************************/");
stringPlus.AppendLine(" /*修改代码-显示 */");
stringPlus.AppendLine(this.GetUpdateShowAspxCs());
stringPlus.AppendLine(" /*修改代码-提交更新 */");
stringPlus.AppendLine(this.GetUpdateAspxCs());
}
if (ShowForm)
{
stringPlus.AppendLine(" /******************************显示窗体代码********************************/");
stringPlus.AppendLine(this.GetShowAspxCs());
}
return(stringPlus.Value);
}
public string GetShowAspx()
{
StringPlus stringPlus = new StringPlus();
stringPlus.AppendLine();
stringPlus.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">");
foreach (ColumnInfo current in this.Fieldlist)
{
string columnName = current.ColumnName;
string typeName = current.TypeName;
string text = current.Description;
text = CodeCommon.CutDescText(text, 15, columnName);
stringPlus.AppendSpaceLine(1, "<tr>");
stringPlus.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">");
stringPlus.AppendSpaceLine(2, text);
stringPlus.AppendSpaceLine(1, "：</td>");
stringPlus.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">");
typeName.Trim().ToLower();
stringPlus.AppendSpaceLine(2, "<asp:Label id=\"lbl" + columnName + "\" runat=\"server\"></asp:Label>");
stringPlus.AppendSpaceLine(1, "</td></tr>");
}
stringPlus.AppendLine("</table>");
return(stringPlus.ToString());
}
/// <summary>
/// 得到GetModel()的代码
/// </summary>
/// <param name="DbName"></param>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <param name="ModelName"></param>
/// <returns></returns>
public string CreatGetModel()
{
//if (ModelSpace == "")
//{
// ModelSpace = "ModelClassName"; ;
//}
StringPlus strclass = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// 得到一个对象实体");
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public " + ModelSpace + " GetModel(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"select " + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" " + Fieldstrlist + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" from " + _tablename + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + LTP.CodeHelper.CodeCommon.GetWhereExpression(Keys) + "\" );");
strclass.AppendSpaceLine(3, "Database db = DatabaseFactory.CreateDatabase();");
strclass.AppendSpaceLine(3, "DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());");
strclass.AppendSpaceLine(3, "" + ModelSpace + " model=null;");
strclass.AppendSpaceLine(3, "using (IDataReader dataReader = db.ExecuteReader(dbCommand))");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "if(dataReader.Read())");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model=ReaderBind(dataReader);");
strclass.AppendSpaceLine(4, "}");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "return model;");
strclass.AppendSpaceLine(2, "}");
return(strclass.Value);
}
/// <summary>
/// 得到某字段最大值的方法代码(只有主键是int型的情况下生成)
/// </summary>
/// <param name="TabName"></param>
/// <param name="ID"></param>
/// <returns></returns>
public string CreatGetMaxID()
{
StringPlus strclass = new StringPlus();
if (_keys.Count > 0)
{
string keyname = "";
foreach (ColumnInfo obj in _keys)
{
if (CodeCommon.DbTypeToCS(obj.TypeName) == "int")
{
keyname = obj.ColumnName;
if (obj.IsPK)
{
strclass.AppendLine("");
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// 得到最大ID");
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public int GetMaxId()");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "string strsql = \"select max(" + keyname + ")+1 from " + _tablename + "\";");
strclass.AppendSpaceLine(3, "Database db = DatabaseFactory.CreateDatabase();");
strclass.AppendSpaceLine(3, "object obj = db.ExecuteScalar(CommandType.Text, strsql);");
strclass.AppendSpaceLine(3, "if (obj != null && obj != DBNull.Value)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return int.Parse(obj.ToString());");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "return 1;");
strclass.AppendSpaceLine(2, "}");
break;
}
}
}
}
return(strclass.ToString());
}
public string CreatBLLGetModelByCache(string ModelName)
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetModelByCache"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public " + ModelSpace + " GetModelByCache(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, KeysNullTip);
string para = "";
if (Keys.Count > 0)
{
para = "+ " + Maticsoft.CodeHelper.CodeCommon.GetFieldstrlistAdd(Keys, true);
}
strclass.AppendSpaceLine(3, "string CacheKey = \"" + ModelName + "Model-\" " + para + ";");
strclass.AppendSpaceLine(3, "object objModel = Maticsoft.Common.DataCache.GetCache(CacheKey);");
strclass.AppendSpaceLine(3, "if (objModel == null)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "try");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "objModel = dal.GetModel(" + Maticsoft.CodeHelper.CodeCommon.GetFieldstrlist(Keys, true) + ");");
strclass.AppendSpaceLine(5, "if (objModel != null)");
strclass.AppendSpaceLine(5, "{");
strclass.AppendSpaceLine(6, "int ModelCache = Maticsoft.Common.ConfigHelper.GetConfigInt(\"ModelCache\");");
//strclass.AppendSpaceLine(6, "int ModelCache = Globals.SafeInt(BLL.SysManage.ConfigSystem.GetValueByCache(\"CacheTime\"), 30);");
strclass.AppendSpaceLine(6, "Maticsoft.Common.DataCache.SetCache(CacheKey, objModel, DateTime.Now.AddMinutes(ModelCache), TimeSpan.Zero);");
strclass.AppendSpaceLine(5, "}");
strclass.AppendSpaceLine(4, "}");
strclass.AppendSpaceLine(4, "catch{}");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "return (" + ModelSpace + ")objModel;");
strclass.AppendSpaceLine(2, "}");
return(strclass.Value);
}
/// <summary>
/// 生成完整Model类
/// </summary>
public string CreatModel()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine("using System;");
strclass.AppendLine("namespace " + Modelpath);
strclass.AppendLine("{");
strclass.AppendSpaceLine(1, "/// <summary>");
if (TableDescription.Length > 0)
{
strclass.AppendSpaceLine(1, "/// 【Model】: " + TableDescription.Replace("\r\n", "\r\n\t///"));
}
else
{
strclass.AppendSpaceLine(1, "/// 【Model】: " + _modelname /*+ ":" + Languagelist["summary"].ToString()*/);
}
strclass.AppendSpaceLine(1, "/// </summary>");
strclass.AppendSpaceLine(1, "[Serializable]");
strclass.AppendSpaceLine(1, "public partial class " + _modelname);
strclass.AppendSpaceLine(1, "{");
strclass.AppendSpaceLine(2, "public " + _modelname + "()");
strclass.AppendSpaceLine(2, "{}");
strclass.AppendLine(CreatModelMethod());
strclass.AppendSpaceLine(1, "}");
strclass.AppendLine("}");
strclass.AppendLine("");
if (Modelpath.Contains("Maticsoft"))//如果为默认命名空间直接返回
{
return(strclass.ToString());
}
else//否则直接替换原始命名空间
{
return(strclass.ToString().Replace("Maticsoft", Modelpath.Split('.')[0]));
}
}
/// <summary>
/// 生成INSERT查询语句
/// </summary>
/// <param name="dbname">库名</param>
/// <param name="tablename">表名</param>
/// <returns></returns>
public string GetSQLInsert(string dbname, string tablename)
{
dbobj.DbConnectStr = _dbconnectStr;
//DataTable dt = dbobj.GetColumnList(dbname, tablename);
List <ColumnInfo> collist = dbobj.GetColumnList(dbname, tablename);
this.DbName = dbname;
this.TableName = tablename;
StringPlus strsql = new StringPlus();
StringPlus strsql2 = new StringPlus();
strsql.AppendLine("INSERT INTO [" + tablename + "] ( ");
if ((collist != null) && (collist.Count > 0))
{
foreach (ColumnInfo col in collist)
{
string columnName = col.ColumnName;
string columnType = col.TypeName;
strsql.AppendLine("[" + columnName + "] ,");
if (LTP.CodeHelper.CodeCommon.IsAddMark(columnType))
{
strsql2.Append("'" + columnName + "',");
}
else
{
strsql2.Append(columnName + ",");
}
}
strsql.DelLastComma();
strsql2.DelLastComma();
}
strsql.Append(") VALUES (" + strsql2.Value + ")");
return(strsql.Value);
}
public static string GetWhereExpression(List <ColumnInfo> keys, bool IdentityisPrior)
{
StringPlus stringPlus = new StringPlus();
ColumnInfo identityKey = CodeCommon.GetIdentityKey(keys);
if (IdentityisPrior && identityKey != null)
{
if (CodeCommon.IsAddMark(identityKey.TypeName))
{
stringPlus.Append(identityKey.ColumnName + "='\"+" + identityKey.ColumnName + "+\"'");
}
else
{
stringPlus.Append(identityKey.ColumnName + "=\"+" + identityKey.ColumnName + "+\"");
}
}
else
{
foreach (ColumnInfo current in keys)
{
if (current.IsPrimaryKey || !current.IsIdentity)
{
if (CodeCommon.IsAddMark(current.TypeName))
{
stringPlus.Append(current.ColumnName + "='\"+" + current.ColumnName + "+\"' and ");
}
else
{
stringPlus.Append(current.ColumnName + "=\"+" + current.ColumnName + "+\" and ");
}
}
}
stringPlus.DelLastChar("and");
}
return(stringPlus.Value);
}
/// <summary>
/// 生成获取实体代码
/// </summary>
/// <param name="tableName"></param>
/// <param name="keyColumnList"></param>
/// <returns></returns>
private string BuildCode_GetModel(string tableName, List <Column> keyColumnList)
{
StringPlus sp = new StringPlus();
//注释
sp.AppendSpaceLine(1, "/// <summary>");
sp.AppendSpaceLine(1, "/// " + "获取模型");
sp.AppendSpaceLine(1, "/// </summary>");
//方法头
string strFun = string.Format("public {0} GetModel({1})", tableName, BuildHelper.BuildParameterListString(keyColumnList, true));
sp.AppendSpaceLine(1, strFun);
//方法体
sp.AppendSpaceLine(1, "{");
sp.AppendSpaceLine(2, string.Format("{0} model = null;", tableName));
sp.AppendSpaceLine(2, string.Format("DataTable dt = GetModelTable({0});", BuildHelper.BuildParameterListString(keyColumnList, false)));
sp.AppendSpaceLine(2, string.Format("model = DataTableHelper.CreateItem<{0}>(dt.Rows[0]);", tableName));
sp.AppendSpaceLine(2, "return model;");
sp.AppendSpaceLine(1, "}");
return(sp.ToString());
}
/// <summary>
/// 导出Excel
/// </summary>
/// <returns></returns>
private string DeriveData()
{
int count = 0;
DataTable dt = GetList(ref count);
if (dt != null && dt.Rows.Count > 0)
{
string ExcelFolder = "ExcelFolder";// Assistant.GetConfigString("ExcelFolder");
string filename = DateTime.Now.ToString("yyyyMMddHHmmssff") + ".xls";
string msg = string.Empty;
if (dt != null && dt.Rows.Count > 0)
{
dt.Columns.Remove("Ro");
dt.Columns.Remove("CBDW_BM");
dt.Columns["CBDW_MC"].ColumnName = "承办单位";
dt.Columns["AJNUM"].ColumnName = "制作案件数";
dt.Columns["JNUM"].ColumnName = "卷数";
dt.Columns["WJNUM"].ColumnName = "文件数";
dt.Columns["WJYNUM"].ColumnName = "文件页数";
msg = DataToExcel_Ex.Export(dt, "卷宗制作量统计", Server.MapPath("/" + ExcelFolder + "/" + filename));
//filename = dte.DataExcel(dt, "卷宗制作量统计", FilePath, nameList, null);
}
if (string.IsNullOrEmpty(msg))
{
return(ReturnString.JsonToString(Prompt.win, "/" + ExcelFolder + "/" + filename, null));
}
else
{
return(ReturnString.JsonToString(Prompt.error, StringPlus.String2Json(msg), null));
}
}
return(ReturnString.JsonToString(Prompt.error, "导出失败", null));
}
public string GetShowAspxCs()
{
//LTP.BuilderWeb.BuilderWeb bw = CreatBuilderWeb();
if (ibw == null)
{
return("//请选择有效的表示层代码组件！");
}
string cs = ibw.GetShowAspxCs();
StringPlus strcode = new StringPlus();
//strcode.AppendSpaceLine(2, "protected void Page_LoadComplete(object sender, EventArgs e)");
//strcode.AppendSpaceLine(2, "{");
//strcode.AppendSpaceLine(3, "(Master.FindControl(\"lblTitle\") as Label).Text = \"详细信息\";");
//strcode.AppendSpaceLine(2, "}");
strcode.AppendSpaceLine(2, "protected void Page_Load(object sender, EventArgs e)");
strcode.AppendSpaceLine(2, "{");
strcode.AppendSpaceLine(3, "if (!Page.IsPostBack)");
strcode.AppendSpaceLine(3, "{");
strcode.AppendSpaceLine(4, "if (Request.Params[\"id\"] != null && Request.Params[\"id\"].Trim() != \"\")");
strcode.AppendSpaceLine(4, "{");
strcode.AppendSpaceLine(5, "string id = Request.Params[\"id\"];");
if (_keys.Count > 0)
{
strcode.AppendSpaceLine(5, "//ShowInfo(" + LTP.CodeHelper.CodeCommon.GetFieldstrlist(Keys) + ");");
}
else
{
strcode.AppendSpaceLine(5, "ShowInfo();");
}
strcode.AppendSpaceLine(4, "}");
strcode.AppendSpaceLine(3, "}");
strcode.AppendSpaceLine(2, "}");
strcode.AppendSpaceLine(2, cs);
return(strcode.ToString());
}
/// <summary>
/// 得到表示层增加窗体的html代码
/// </summary>
public string GetUpdateAspx()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine("");
strclass.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.DeText;
bool ispk = field.IsPK;
bool IsIdentity = field.IsIdentity;
if (deText.Trim() == "")
{
deText = columnName;
}
if ((ispk) || (IsIdentity))
{
strclass.AppendSpaceLine(1, "<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">");
strclass.AppendSpaceLine(2, deText);
strclass.AppendSpaceLine(1, "：</td>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">");
strclass.AppendSpaceLine(2, "<asp:label id=\"lbl" + columnName + "\" runat=\"server\"></asp:label>");
strclass.AppendSpaceLine(1, "</td></tr>");
}
else
{
//
strclass.AppendSpaceLine(1, "<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">");
strclass.AppendSpaceLine(2, deText);
strclass.AppendSpaceLine(1, "：</td>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">");
switch (columnType.Trim())
{
case "datetime":
case "smalldatetime":
strclass.AppendSpaceLine(2, "<INPUT onselectstart=\"return false;\" onkeypress=\"return false\" id=\"txt" + columnName + "\" onfocus=\"setday(this)\"");
strclass.AppendSpaceLine(2, " readOnly type=\"text\" size=\"10\" name=\"Text1\" runat=\"server\">");
break;
case "bit":
strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />");
break;
default:
strclass.AppendSpaceLine(2, "<asp:TextBox id=\"txt" + columnName + "\" runat=\"server\" Width=\"200px\"></asp:TextBox>");
break;
}
strclass.AppendSpaceLine(1, "</td></tr>");
}
}
//按钮
strclass.AppendSpaceLine(1, "<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" colspan=\"2\"><div align=\"center\">");
strclass.AppendSpaceLine(2, "<asp:Button ID=\"btnAdd\" runat=\"server\" Text=\"· 提交 ·\" OnClick=\"btnAdd_Click\" ></asp:Button>");
//strclass.AppendSpaceLine(2, "<asp:Button ID=\"btnCancel\" runat=\"server\" Text=\"· 取消 ·\" OnClick=\"btnCancel_Click\" ></asp:Button>");
strclass.AppendSpaceLine(1, "</div></td></tr>");
strclass.AppendLine("</table>");
return(strclass.Value);
}
/// <summary>
/// 获取配置文件中串口线路的信息
/// </summary>
public static List <ComConfig> GetComConfig()
{
try
{
List <ComConfig> ls = new List <ComConfig>();
List <string> strName = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComName"), ';', true);
List <string> strBaudRate = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComBaudRate"), ';', false);
List <string> strParity = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComParity"), ';', false);
List <string> strStopBits = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComStopBits"), ';', false);
List <string> strComTimeout = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComTimeout"), ';', false);
List <string> strRefreshPeriod = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComRefreshPeriod"), ';', false);
List <string> strConnectCheckPeriod = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComConnectCheckPeriod"), ';', false);
List <string> strComInterFrameGap = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComInterFrameGap"), ';', false);
List <string> strDeviceID = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComDeviceID"), ';', false);
List <string> strDeviceType = StringPlus.GetStrArray(ConfigHelper.GetConfigString("ComDeviceType"), ';', true);
List <int> baudrate = new List <int>();
foreach (string str in strBaudRate)
{
baudrate.Add(int.Parse(str));
}
List <Parity> parity = new List <Parity>();
foreach (string str in strParity)
{
parity.Add(((Parity)(int.Parse(str))));
}
List <StopBits> stop = new List <StopBits>();
foreach (string str in strStopBits)
{
stop.Add(((StopBits)(int.Parse(str))));
}
for (int i = 0; i < strName.Count; i++)
{
ComConfig cc = new ComConfig();
cc.ComPort = new SerialPort(strName[i], baudrate[i], parity[i], 8, stop[i]);
cc.Timeout = int.Parse(strComTimeout[i]);
cc.RefreshPeriod = int.Parse(strRefreshPeriod[i]);
cc.ConnectCheckPeriod = int.Parse(strConnectCheckPeriod[i]);
cc.InterFrameGap = int.Parse(strComInterFrameGap[i]);
Log.InfoFormat("解析串口线路配置信息：{0},{1},{2},{3},刷新周期{4}(ms),连接检测周期{5}(ms),超时{6}(ms),帧间隙{7}(ms)",
cc.ComPort.PortName, cc.ComPort.BaudRate, cc.ComPort.Parity.ToString(),
cc.ComPort.StopBits.ToString(), cc.RefreshPeriod, cc.ConnectCheckPeriod,
cc.Timeout, cc.InterFrameGap);
cc.Device = new Dictionary <byte, string>();
List <string> deviceID = StringPlus.GetStrArray(strDeviceID[i], ',', false);
List <string> deviceType = StringPlus.GetStrArray(strDeviceType[i], ',', false);
for (int j = 0; j < deviceID.Count; j++)
{
cc.Device.Add(byte.Parse(deviceID[j]), deviceType[j]);
Log.InfoFormat("解析串口线路配置信息：设备通讯地址[{0}],类型[{1}]", deviceID[j], deviceType[j]);
}
ls.Add(cc);
}
return(ls);
}
catch (System.Exception ex)
{
string str = "解析串口线路配置信息出错，程序无法继续执行: " + ex.Message;
Log.Fatal(str);
throw new Exception(str);
}
}
/// <summary>
/// �õ��Ĵ���Ĵ���
/// </summary>
public string GetUpdateShowAspxCs()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
string key = Key;
strclass.AppendSpaceLine(1, "private void ShowInfo(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")");
strclass.AppendSpaceLine(1, "{");
strclass.AppendSpaceLine(2, BLLSpace + " bll=new " + BLLSpace + "();");
strclass.AppendSpaceLine(2, ModelSpace + " model=bll.GetModel(" + Maticsoft.CodeHelper.CodeCommon.GetFieldstrlist(Keys, true) + ");");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
if (isFilterColume(columnName))
{
continue;
}
//���Զ���-�����ֶδ���
//if ((columnName.IndexOf("_cLang") > 0) && (columnType.Trim().ToLower() == "varchar"))
//{
// strclass.AppendSpaceLine(2, "UCDroplistLanguage1.LanguageCode =model." + columnName + ";");
// continue;
//}
//if (columnName.IndexOf("_iAuthority") > 0)
//{
// strclass.AppendSpaceLine(2, "UCDroplistPermission1.PermissionID =model." + columnName + ";");
// continue;
//}
//if (columnName.IndexOf("_cCurrency") > 0)//���Ҵ���
//{
// strclass.AppendSpaceLine(2, "UCDroplistCurrency1.CurrencyCode =model." + columnName + ";");
// continue;
//}
//if (columnName.IndexOf("_cCurrencyUnit") > 0)//���Ҵ���
//{
// strclass.AppendSpaceLine(2, "UCDroplistCurrencyUnit1.CurrencyUnitID =model." + columnName + ";");
// continue;
//}
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "long":
case "smallint":
case "float":
case "numeric":
case "decimal":
case "datetime":
case "smalldatetime":
if ((ispk) || (IsIdentity))
{
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();");
}
else
{
strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ".ToString();");
}
break;
case "bool":
strclass.AppendSpaceLine(2, "this.chk" + columnName + ".Checked=model." + columnName + ";");
break;
case "byte[]":
strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ".ToString();");
break;
case "guid":
case "uniqueidentifier":
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();");
break;
default:
if ((ispk) || (IsIdentity))
{
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ";");
}
else
{
strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ";");
}
break;
}
}
strclass.AppendLine();
strclass.AppendSpaceLine(1, "}");
return strclass.Value;
}
/// <summary>
/// �õ��Ĵ���Ĵ���
/// </summary>
public string GetUpdateAspxCs()
{
StringPlus strclass = new StringPlus();
StringPlus strclass0 = new StringPlus();
StringPlus strclass1 = new StringPlus();
StringPlus strclass2 = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(3, "string strErr=\"\";");
//bool ishasuser = false;
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
//���Զ���-�����ֶδ���
//if (
// (columnName.IndexOf("_iCreator") > 0) || //ҳ�治��Ҫ��2��
// (columnName.IndexOf("_dateCreate") > 0) ||
// (columnName.IndexOf("_bValid") > 0) ||
// (columnName.IndexOf("_dateValid") > 0) ||
// (columnName.IndexOf("_dateExpire") > 0)
// )
//{
// continue;
//}
//if ((!ishasuser) && (columnName.IndexOf("_iMaintainer") > 0))
//{
// strclass0.AppendSpaceLine(4, "User currentUser;");
// strclass0.AppendSpaceLine(3, "if (Session[\"UserInfo\"] != null)");
// strclass0.AppendSpaceLine(3, "{");
// strclass0.AppendSpaceLine(4, "currentUser = (User)Session[\"UserInfo\"];");
// strclass0.AppendSpaceLine(3, "}else{");
// strclass0.AppendSpaceLine(4, "return;");
// strclass0.AppendSpaceLine(3, "}");
// ishasuser = true;
//}
deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
//���Զ���-�����ֶδ���
//if ((columnName.IndexOf("_cLang") > 0) && (columnType.Trim().ToLower() == "varchar"))//���Դ���
//{
// strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistLanguage1.LanguageCode;");
// continue;
//}
//if (columnName.IndexOf("_iAuthority") > 0)//Ȩ��ɫ����
//{
// strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistPermission1.PermissionID;");
// continue;
//}
//if (columnName.IndexOf("_cCurrency") > 0)//���Ҵ���
//{
// strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistCurrency1.CurrencyCode;");
// continue;
//}
//if (columnName.IndexOf("_cCurrencyUnit") > 0)//���Ҵ���
//{
// strclass2.AppendSpaceLine(3, "model." + columnName + "= UCDroplistCurrencyUnit1.CurrencyUnitID;");
// continue;
//}
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "smallint":
if ((ispk) || (IsIdentity))
{
strclass0.AppendSpaceLine(3, "int " + columnName + "=int.Parse(this.lbl" + columnName + ".Text);");
}
else
{
strclass0.AppendSpaceLine(3, "int " + columnName + "=int.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsNumber(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
}
break;
case "long":
if ((ispk) || (IsIdentity))
{
strclass0.AppendSpaceLine(3, "long " + columnName + "=long.Parse(this.lbl" + columnName + ".Text);");
}
else
{
strclass0.AppendSpaceLine(3, "long " + columnName + "=long.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsNumber(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
}
break;
case "float":
case "numeric":
case "decimal":
if ((ispk) || (IsIdentity))
{
strclass0.AppendSpaceLine(3, "decimal " + columnName + "=decimal.Parse(this.lbl" + columnName + ".Text);");
}
else
{
strclass0.AppendSpaceLine(3, "decimal " + columnName + "=decimal.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDecimal(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
}
break;
case "datetime":
case "smalldatetime":
strclass0.AppendSpaceLine(3, "DateTime " + columnName + "=DateTime.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDateTime(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
case "bool":
strclass0.AppendSpaceLine(3, "bool " + columnName + "=this.chk" + columnName + ".Checked;");
break;
case "byte[]":
strclass0.AppendSpaceLine(3, "byte[] " + columnName + "= new UnicodeEncoding().GetBytes(this.txt" + columnName + ".Text);");
break;
case "guid":
case "uniqueidentifier":
strclass0.AppendSpaceLine(3, "Guid " + columnName + "= new Guid(this.lbl" + columnName + ".Text);");
break;
default:
if ((ispk) || (IsIdentity))
{
strclass0.AppendSpaceLine(3, "string " + columnName + "=this.lbl" + columnName + ".Text;");
}
else
{
strclass0.AppendSpaceLine(3, "string " + columnName + "=this.txt" + columnName + ".Text;");
strclass1.AppendSpaceLine(3, "if(this.txt" + columnName + ".Text.Trim().Length==0)");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "����Ϊ�գ�\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
}
break;
}
strclass2.AppendSpaceLine(3, "model." + columnName + "=" + columnName + ";");
}
strclass.AppendLine(strclass1.ToString());
strclass.AppendSpaceLine(3, "if(strErr!=\"\")");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "MessageBox.Show(this,strErr);");
strclass.AppendSpaceLine(4, "return;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendLine(strclass0.ToString());
strclass.AppendLine();
strclass.AppendSpaceLine(3, ModelSpace + " model=new " + ModelSpace + "();");
strclass.AppendLine(strclass2.ToString());
strclass.AppendSpaceLine(3, BLLSpace + " bll=new " + BLLSpace + "();");
strclass.AppendSpaceLine(3, "bll.Update(model);");
strclass.AppendSpaceLine(3, "Maticsoft.Common.MessageBox.ShowAndRedirect(this,\"����ɹ���\",\"list.aspx\");");
return strclass.ToString();
}
/// <summary>
/// ��ʾ�����html����
/// </summary>
public string GetShowDesigner()
{
StringPlus strclass = new StringPlus();
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
//case "bool":
// strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.CheckBox chk" + columnName + ";");
// break;
default:
strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Label lbl" + columnName + ";");
break;
}
}
return strclass.ToString();
}
/// <summary>
/// �õ���ʾ����ʾ�����html����
/// </summary>
public string GetShowAspx()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
strclass.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
strclass.AppendSpaceLine(1, "<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">");
strclass.AppendSpaceLine(2, deText);
strclass.AppendSpaceLine(1, "��</td>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">");
switch (columnType.Trim().ToLower())
{
//case "bit":
// strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />" );
// break;
default:
strclass.AppendSpaceLine(2, "<asp:Label id=\"lbl" + columnName + "\" runat=\"server\"></asp:Label>");
break;
}
strclass.AppendSpaceLine(1, "</td></tr>");
}
strclass.AppendLine("</table>");
return strclass.ToString();
}
/// <summary>
/// �õ�GetList()�Ĵ���
/// </summary>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <returns></returns>
public string CreatGetListByPageProc()
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(2, "/*");
//strclass.AppendSpaceLine(2, "/// <summary>");
//strclass.AppendSpaceLine(2, "/// "+Languagelist["summaryGetList3"].ToString());
//strclass.AppendSpaceLine(2, "/// </summary>");
//strclass.AppendSpaceLine(2, "public DataSet GetList(int PageSize,int PageIndex,string strWhere)");
//strclass.AppendSpaceLine(2, "{");
//strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "tblName\", " + DbParaDbType + ".VarChar, 255),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "fldName\", " + DbParaDbType + ".VarChar, 255),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "PageSize\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "int") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "PageIndex\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "int") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "IsReCount\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "bit") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "OrderType\", " + DbParaDbType + "." + CodeCommon.CSToProcType(dbobj.DbType, "bit") + "),");
//strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "strWhere\", " + DbParaDbType + ".VarChar,1000),");
//strclass.AppendSpaceLine(5, "};");
//strclass.AppendSpaceLine(3, "parameters[0].Value = \"" + TableName + "\";");
//strclass.AppendSpaceLine(3, "parameters[1].Value = \"" + _key + "\";");
//strclass.AppendSpaceLine(3, "parameters[2].Value = PageSize;");
//strclass.AppendSpaceLine(3, "parameters[3].Value = PageIndex;");
//strclass.AppendSpaceLine(3, "parameters[4].Value = 0;");
//strclass.AppendSpaceLine(3, "parameters[5].Value = 0;");
//strclass.AppendSpaceLine(3, "parameters[6].Value = strWhere; ");
//strclass.AppendSpaceLine(3, "return " + DbHelperName + ".RunProcedure(\"UP_GetRecordByPage\",parameters,\"ds\");");
//strclass.AppendSpaceLine(2, "}");
strclass.AppendSpaceLine(2, "*/");
return strclass.Value;
}
/// <summary>
/// �õ���ҳ�����Ĵ���
/// </summary>
public string CreatGetListByPage()
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["GetRecordCount"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public int GetRecordCount(string strWhere)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"select count(1) FROM " + TableName + " \");");
strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "object obj = DbHelperSQL.GetSingle(strSql.ToString());");
strclass.AppendSpaceLine(3, "if (obj == null)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return 0;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return Convert.ToInt32(obj);");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(2, "}");
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList3"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public DataSet GetListByPage(string strWhere, string orderby, int startIndex, int endIndex)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"SELECT * FROM ( \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" SELECT ROW_NUMBER() OVER (\");");
strclass.AppendSpaceLine(3, "if (!string.IsNullOrEmpty(orderby.Trim()))");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql.Append(\"order by T.\" + orderby );");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql.Append(\"order by T." + _IdentityKey + " desc\");");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "strSql.Append(\")AS Row, T.* from " + TableName + " T \");");
strclass.AppendSpaceLine(3, "if (!string.IsNullOrEmpty(strWhere.Trim()))");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql.Append(\" WHERE \" + strWhere);");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "strSql.Append(\" ) TT\");");
strclass.AppendSpaceLine(3, "strSql.AppendFormat(\" WHERE TT.Row between {0} and {1}\", startIndex, endIndex);");
strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());");
strclass.AppendSpaceLine(2, "}");
return strclass.Value;
}
/// <summary>
/// �õ�GetList()�Ĵ���
/// </summary>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <returns></returns>
public string CreatGetList()
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public DataSet GetList(string strWhere)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpace(3, "strSql.Append(\"select ");
strclass.AppendLine(Fieldstrlist + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" FROM " + TableName + " \");");
strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());");
strclass.AppendSpaceLine(2, "}");
if ((dbobj.DbType == "SQL2000") ||
(dbobj.DbType == "SQL2005") ||
(dbobj.DbType == "SQL2008") ||
(dbobj.DbType == "SQL2012"))
{
strclass.AppendLine();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList2"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public DataSet GetList(int Top,string strWhere,string filedOrder)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"select \");");
strclass.AppendSpaceLine(3, "if(Top>0)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql.Append(\" top \"+Top.ToString());");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "strSql.Append(\" " + Fieldstrlist + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" FROM " + TableName + " \");");
strclass.AppendSpaceLine(3, "if(strWhere.Trim()!=\"\")");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql.Append(\" where \"+strWhere);");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "strSql.Append(\" order by \" + filedOrder);");
strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Query(strSql.ToString());");
strclass.AppendSpaceLine(2, "}");
}
//����List<>
strclass.AppendLine(); // ���峬 2015-10-13
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public List<" + ModelSpace + "> GetModelList(string strWhere)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "DataSet ds = GetList(strWhere);");
strclass.AppendSpaceLine(3, "return DataTableToList(ds.Tables[0]);");
strclass.AppendSpaceLine(2, "}");
//����List<>
strclass.AppendLine();// ���峬 2015-10-13
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetList"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public List<" + ModelSpace + "> DataTableToList(DataTable dt)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "List<" + ModelSpace + "> modelList = new List<" + ModelSpace + ">();");
strclass.AppendSpaceLine(3, "int rowsCount = dt.Rows.Count;");
strclass.AppendSpaceLine(3, "if (rowsCount > 0)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, ModelSpace + " model;");
strclass.AppendSpaceLine(4, "for (int n = 0; n < rowsCount; n++)");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model = DataRowToModel(dt.Rows[n]);");
strclass.AppendSpaceLine(5, "if (model != null)");
strclass.AppendSpaceLine(5, "{");
strclass.AppendSpaceLine(6, "modelList.Add(model);");
strclass.AppendSpaceLine(5, "}");
strclass.AppendSpaceLine(4, "}");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "return modelList;");
strclass.AppendSpaceLine(2, "}");
return strclass.Value;
}
/// <summary>
/// �õ�Exists�����Ĵ���
/// </summary>
/// <param name="_tablename"></param>
/// <param name="ID"></param>
/// <returns></returns>
public string CreatExists()
{
StringPlus strclass = new StringPlus();
if (_keys.Count > 0)
{
string strInparam = Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, false);
if (!string.IsNullOrEmpty(strInparam))
{
strclass.AppendLine("");
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryExists"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public bool Exists(" + strInparam + ")");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"select count(1) from " + _tablename + "\");");
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + Maticsoft.CodeHelper.CodeCommon.GetWhereExpression(Keys, false) + "\");");
strclass.AppendSpaceLine(3, "return " + DbHelperName + ".Exists(strSql.ToString());");
strclass.AppendSpace(2, "}");
}
}
return strclass.ToString();
}
/// <summary>
/// �õ�Delete�Ĵ���
/// </summary>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <returns></returns>
public string CreatDelete()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine("");
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryDelete"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public bool Delete(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
//if (dbobj.DbType != "OleDb")
//{
// strclass.AppendSpaceLine(3, "strSql.Append(\"delete " + _tablename + " \");" );
//}
//else
//{
strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablename + " \");");
//}
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + Maticsoft.CodeHelper.CodeCommon.GetWhereExpression(Keys, true) + "\" );");
strclass.AppendSpaceLine(3, "int rowsAffected=" + DbHelperName + ".ExecuteSql(strSql.ToString());");
strclass.AppendSpaceLine(3, "if (rowsAffected > 0)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return true;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return false;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpace(2, "}");
#region �����������ȵ�ɾ��(���б�ʶ�ֶΣ����зDZ�ʶ�����ֶ�)
if ((Maticsoft.CodeHelper.CodeCommon.HasNoIdentityKey(Keys)) && (Maticsoft.CodeHelper.CodeCommon.GetIdentityKey(Keys) != null))
{
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryDelete"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public bool Delete(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, false) + ")");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, KeysNullTip);
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablename + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + GetWhereExpression(Keys, false) + "\");");
strclass.AppendLine(GetPreParameter(Keys, false));
strclass.AppendSpaceLine(3, "int rows=" + DbHelperName + ".ExecuteSql(strSql.ToString(),parameters);");
strclass.AppendSpaceLine(3, "if (rows > 0)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return true;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return false;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(2, "}");
}
#endregion
#region ����ɾ������
string keyField = "";
if (Keys.Count == 1)
{
keyField = Keys[0].ColumnName;
}
else
{
foreach (ColumnInfo field in Keys)
{
if (field.IsIdentity)
{
keyField = field.ColumnName;
break;
}
}
}
if (keyField.Trim().Length > 0)
{
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryDeletelist"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public bool DeleteList(string " + keyField + "list )");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"delete from " + _tablename + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + keyField + " in (\"+" + keyField + "list + \") \");");
strclass.AppendSpaceLine(3, "int rows=" + DbHelperName + ".ExecuteSql(strSql.ToString());");
strclass.AppendSpaceLine(3, "if (rows > 0)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return true;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return false;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(2, "}");
}
#endregion
return strclass.ToString();
}
/// <summary>
/// DataRowToModel�Ĵ���
/// </summary>
public string CreatDataRowToModel()
{
if (ModelSpace == "")
{
//ModelSpace = "ModelClassName"; ;
}
StringPlus strclass = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetModel"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public " + ModelSpace + " DataRowToModel(DataRow row)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "" + ModelSpace + " model=new " + ModelSpace + "();");
strclass.AppendSpaceLine(3, "if (row != null)");
strclass.AppendSpaceLine(3, "{");
#region �ֶθ�ֵ
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
//strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
//strclass.AppendSpaceLine(4, "{");
#region
switch (CodeCommon.DbTypeToCS(columnType))
{
case "int":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=int.Parse(row[\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "long":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=long.Parse(row[\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "decimal":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=decimal.Parse(row[\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "float":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=float.Parse(row[\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "DateTime":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=DateTime.Parse(row[\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "string":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null)");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=row[\"" + columnName + "\"].ToString();");
strclass.AppendSpaceLine(4, "}");
}
break;
case "bool":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "if((row[\"" + columnName + "\"].ToString()==\"1\")||(row[\"" + columnName + "\"].ToString().ToLower()==\"true\"))");
strclass.AppendSpaceLine(5, "{");
strclass.AppendSpaceLine(6, "model." + columnName + "=true;");
strclass.AppendSpaceLine(5, "}");
strclass.AppendSpaceLine(5, "else");
strclass.AppendSpaceLine(5, "{");
strclass.AppendSpaceLine(6, "model." + columnName + "=false;");
strclass.AppendSpaceLine(5, "}");
strclass.AppendSpaceLine(4, "}");
}
break;
case "byte[]":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=(byte[])row[\"" + columnName + "\"];");
strclass.AppendSpaceLine(4, "}");
}
break;
case "uniqueidentifier":
case "Guid":
{
strclass.AppendSpaceLine(4, "if(row[\"" + columnName + "\"]!=null && row[\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "= new Guid(row[\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
default:
strclass.AppendSpaceLine(5, "//model." + columnName + "=row[\"" + columnName + "\"].ToString();");
break;
}
#endregion
//strclass.AppendSpaceLine(4, "}");
}
#endregion
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "return model;");
strclass.AppendSpaceLine(2, "}");
return strclass.ToString();
}
/// <summary>
/// �õ�Add()�Ĵ���
/// </summary>
public string CreatAdd()
{
if (ModelSpace == "")
{
//ModelSpace = "ModelClassName"; ;
}
StringPlus strclass = new StringPlus();
strclass.AppendLine("");
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryadd"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
string strretu = "bool";
if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" ||
dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012" || dbobj.DbType == "SQLite") && (IsHasIdentity))
{
strretu = "int";
if (_IdentityKeyType != "int")
{
strretu = _IdentityKeyType;
}
}
//if (dbobj.DbType == "OleDb" && IsHasIdentity)
//{
// strretu = "bool";
//}
//��������ͷ
string strFun = CodeCommon.Space(2) + "public " + strretu + " Add(" + ModelSpace + " model)";
strclass.AppendLine(strFun);
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "StringBuilder strSql1=new StringBuilder();");
strclass.AppendSpaceLine(3, "StringBuilder strSql2=new StringBuilder();");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
bool IsIdentity = field.IsIdentity;
if (IsIdentity)
{
continue;
}
strclass.AppendSpaceLine(3, "if (model." + columnName + " != null)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "strSql1.Append(\"" + columnName + ",\");");
if ((dbobj.DbType == "Oracle") && (columnType.ToLower() == "date" || columnType.ToLower() == "datetime"))
{
strclass.AppendSpaceLine(4, "strSql2.Append(\"to_date('\" + model." + columnName + ".ToString() + \"','YYYY-MM-DD HH24:MI:SS'),\");");
}
else
if (columnType.ToLower() == "bit")
{
strclass.AppendSpaceLine(4, "strSql2.Append(\"\"+(model." + columnName + "? 1 : 0) +\",\");");
}
else
if ("uniqueidentifier" == columnType.ToLower())
{
strclass.AppendSpaceLine(4, "strSql2.Append(\"'\"+ Guid.NewGuid().ToString() +\"',\");");
}
else
if (CodeCommon.IsAddMark(columnType.Trim()))
{
strclass.AppendSpaceLine(4, "strSql2.Append(\"'\"+model." + columnName + "+\"',\");");
}
else
{
strclass.AppendSpaceLine(4, "strSql2.Append(\"\"+model." + columnName + "+\",\");");
}
strclass.AppendSpaceLine(3, "}");
}
strclass.AppendSpaceLine(3, "strSql.Append(\"insert into " + TableName + "(\");");
strclass.AppendSpaceLine(3, "strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));");
strclass.AppendSpaceLine(3, "strSql.Append(\")\");");
strclass.AppendSpaceLine(3, "strSql.Append(\" values (\");");
strclass.AppendSpaceLine(3, "strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));");
strclass.AppendSpaceLine(3, "strSql.Append(\")\");");
if (strretu == "void")
{
strclass.AppendSpaceLine(3, "" + DbHelperName + ".ExecuteSql(strSql.ToString());");
}
else
if (strretu == "bool")
{
strclass.AppendSpaceLine(3, "int rows=" + DbHelperName + ".ExecuteSql(strSql.ToString());");
strclass.AppendSpaceLine(3, "if (rows > 0)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return true;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return false;");
strclass.AppendSpaceLine(3, "}");
}
else//�����Զ�������ֵ
{
if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005"
|| dbobj.DbType == "SQL2008" || dbobj.DbType == "SQL2012") && (IsHasIdentity))
{
strclass.AppendSpaceLine(3, "strSql.Append(\";select @@IDENTITY\");");
}
if ((dbobj.DbType == "SQLite") && (IsHasIdentity))
{
strclass.AppendSpaceLine(3, "strSql.Append(\";select LAST_INSERT_ROWID()\");");
}
strclass.AppendSpaceLine(3, "object obj = " + DbHelperName + ".GetSingle(strSql.ToString());");
strclass.AppendSpaceLine(3, "if (obj == null)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return 0;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
switch (strretu)
{
case "int":
strclass.AppendSpaceLine(4, "return Convert.ToInt32(obj);");
break;
case "long":
strclass.AppendSpaceLine(4, "return Convert.ToInt64(obj);");
break;
case "decimal":
strclass.AppendSpaceLine(4, "return Convert.ToDecimal(obj);");
break;
}
strclass.AppendSpaceLine(3, "}");
}
strclass.AppendSpace(2, "}");
return strclass.ToString();
}
/// <summary>
/// �õ�Where������� - Parameter��ʽ (���磺����Exists Delete GetModel ��where)
/// </summary>
/// <param name="keys"></param>
/// <returns></returns>
public string GetWhereExpression(List<ColumnInfo> keys, bool IdentityisPrior)
{
StringPlus strClass = new StringPlus();
ColumnInfo field = Maticsoft.CodeHelper.CodeCommon.GetIdentityKey(keys);
if ((IdentityisPrior) && (field != null)) //�б�ʶ�ֶ�
{
strClass.Append(field.ColumnName + "=" + preParameter + field.ColumnName);
}
else
{
foreach (ColumnInfo key in keys)
{
if (key.IsPrimaryKey)
{
strClass.Append(key.ColumnName + "=" + preParameter + key.ColumnName + " and ");
}
}
strClass.DelLastChar("and");
}
return strClass.Value;
}
private string BuilderMethod()
{
StringPlus plus = new StringPlus();
plus.AppendSpaceLine(2, "#region Method");
//只读
if (IsView)
{
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 是否只读");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public override bool IsReadOnly()");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "return true;");
plus.AppendSpaceLine(2, "}");
}
Model.ColumnInfo identityColumn = Columns.Find(delegate(Model.ColumnInfo col) { return col.IsIdentity; });
if (null != identityColumn)
{
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 获取实体中的标识列");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public override Field GetIdentityField()");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "return _." + identityColumn.ColumnName + ";");
plus.AppendSpaceLine(2, "}");
}
List<Model.ColumnInfo> primarykeyColumns = Columns.FindAll(delegate(Model.ColumnInfo col) { return col.IsPK; });
if (null != primarykeyColumns && primarykeyColumns.Count > 0)
{
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 获取实体中的主键列");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public override Field[] GetPrimaryKeyFields()");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "return new Field[] {");
StringPlus plus2 = new StringPlus();
foreach (Model.ColumnInfo col in primarykeyColumns)
{
plus2.AppendSpaceLine(4, "_." + col.ColumnName + ",");
}
plus.Append(plus2.ToString().TrimEnd().Substring(0, plus2.ToString().TrimEnd().Length - 1));
plus.AppendLine("};");
plus.AppendSpaceLine(2, "}");
}
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 获取列信息");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public override Field[] GetFields()");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "return new Field[] {");
StringPlus plus3 = new StringPlus();
foreach (ColumnInfo col in Columns)
{
plus3.AppendSpaceLine(4, "_." + col.ColumnName + ",");
}
plus.Append(plus3.ToString().TrimEnd().Substring(0, plus3.ToString().TrimEnd().Length - 1));
plus.AppendLine("};");
plus.AppendSpaceLine(2, "}");
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 获取值信息");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public override object[] GetValues()");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "return new object[] {");
StringPlus plus4 = new StringPlus();
foreach (ColumnInfo col in Columns)
{
plus4.AppendSpaceLine(4, "this._" + col.ColumnName + ",");
}
plus.Append(plus4.ToString().TrimEnd().Substring(0, plus4.ToString().TrimEnd().Length - 1));
plus.AppendLine("};");
plus.AppendSpaceLine(2, "}");
//2015-08-10注释
//plus.AppendSpaceLine(2, "/// <summary>");
//plus.AppendSpaceLine(2, "/// 给当前实体赋值");
//plus.AppendSpaceLine(2, "/// </summary>");
//plus.AppendSpaceLine(2, "public override void SetPropertyValues(IDataReader reader)");
//plus.AppendSpaceLine(2, "{");
//foreach (ColumnInfo col in Columns)
//{
// plus.AppendSpaceLine(3, "this._" + col.ColumnName + " = DataUtils.ConvertValue<" + col.TypeName + ">(reader[\"" + col.ColumnNameRealName + "\"]);");
//}
//plus.AppendSpaceLine(2, "}");
//2015-08-10注释
//plus.AppendSpaceLine(2, "/// <summary>");
//plus.AppendSpaceLine(2, "/// 给当前实体赋值");
//plus.AppendSpaceLine(2, "/// </summary>");
//plus.AppendSpaceLine(2, "public override void SetPropertyValues(DataRow row)");
//plus.AppendSpaceLine(2, "{");
//foreach (ColumnInfo col in Columns)
//{
// plus.AppendSpaceLine(3, "this._" + col.ColumnName + " = DataUtils.ConvertValue<" + col.TypeName + ">(row[\"" + col.ColumnNameRealName + "\"]);");
//}
//plus.AppendSpaceLine(2, "}");
plus.AppendSpaceLine(2, "#endregion");
plus.AppendLine();
plus.AppendSpaceLine(2, "#region _Field");
plus.AppendSpaceLine(2, "/// <summary>");
plus.AppendSpaceLine(2, "/// 字段信息");
plus.AppendSpaceLine(2, "/// </summary>");
plus.AppendSpaceLine(2, "public class _");
plus.AppendSpaceLine(2, "{");
plus.AppendSpaceLine(3, "/// <summary>");
plus.AppendSpaceLine(3, "/// * ");
plus.AppendSpaceLine(3, "/// </summary>");
plus.AppendSpaceLine(3, "public readonly static Field All = new Field(\"*\",\"" + TableName + "\");");
foreach (ColumnInfo col in Columns)
{
plus.AppendSpaceLine(3, "/// <summary>");
plus.AppendSpaceLine(3, "/// " + col.DeText);
plus.AppendSpaceLine(3, "/// </summary>");
plus.AppendSpaceLine(3, "public readonly static Field " + col.ColumnName + " = new Field(\"" + col.ColumnNameRealName + "\",\"" + TableName + "\",\"" + (string.IsNullOrEmpty(col.DeText) ? col.ColumnNameRealName : col.DeText) + "\");");
}
plus.AppendSpaceLine(2, "}");
plus.AppendSpaceLine(2, "#endregion");
plus.AppendLine();
return plus.ToString();
}
/// <summary>
/// �õ�ij�ֶ����ֵ�ķ�������(ֻ��������int�͵����������)
/// </summary>
/// <param name="TabName"></param>
/// <param name="ID"></param>
/// <returns></returns>
public string CreatGetMaxID()
{
StringPlus strclass = new StringPlus();
if (_keys.Count > 0)
{
string keyname = "";
foreach (ColumnInfo obj in _keys)
{
if (CodeCommon.DbTypeToCS(obj.TypeName) == "int")
{
keyname = obj.ColumnName;
if (obj.IsPrimaryKey)
{
strclass.AppendLine("");
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// " + Languagelist["summaryGetMaxId"].ToString());
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public int GetMaxId()");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(2, "return " + DbHelperName + ".GetMaxID(\"" + keyname + "\", \"" + _tablename + "\"); ");
strclass.AppendSpaceLine(2, "}");
break;
}
}
}
}
return strclass.ToString();
}
/// <summary>
/// �����html����
/// </summary>
public string GetListDesigner()
{
StringPlus strclass = new StringPlus();
return strclass.ToString();
}
/// <summary>
/// 得到修改窗体的代码
/// </summary>
public string GetUpdateShowAspxCs()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
string key = Key;
strclass.AppendSpaceLine(1, "private void ShowInfo(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")");
strclass.AppendSpaceLine(1, "{");
strclass.AppendSpaceLine(2, BLLSpace + " bll=new " + BLLSpace + "();");
strclass.AppendSpaceLine(2, ModelSpace + " model=bll.GetModel(" + LTP.CodeHelper.CodeCommon.GetFieldstrlist(Keys) + ");");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.DeText;
bool ispk = field.IsPK;
bool IsIdentity = field.IsIdentity;
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "smallint":
case "float":
case "numeric":
case "decimal":
case "datetime":
case "smalldatetime":
if ((ispk) || (IsIdentity))
{
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();");
}
else
{
strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ".ToString();");
}
break;
case "bool":
strclass.AppendSpaceLine(2, "this.chk" + columnName + ".Checked=model." + columnName + ";");
break;
case "byte[]":
strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ".ToString();");
break;
default:
if ((ispk) || (IsIdentity))
{
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ";");
}
else
{
strclass.AppendSpaceLine(2, "this.txt" + columnName + ".Text=model." + columnName + ";");
}
break;
}
}
strclass.AppendLine();
strclass.AppendSpaceLine(1, "}");
return(strclass.Value);
}
/// <summary>
/// �õ���ʾ����ʾ����Ĵ���
/// </summary>
public string GetShowAspxCs()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
string key = Key;
strclass.AppendSpaceLine(1, "private void ShowInfo(" + Maticsoft.CodeHelper.CodeCommon.GetInParameter(Keys, true) + ")");
strclass.AppendSpaceLine(1, "{");
strclass.AppendSpaceLine(2, BLLSpace + " bll=new " + BLLSpace + "();");
strclass.AppendSpaceLine(2, ModelSpace + " model=bll.GetModel(" + Maticsoft.CodeHelper.CodeCommon.GetFieldstrlist(Keys, true) + ");");
//bool ishasuser = false;
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
//if ((ispk) || (IsIdentity))
//{
// continue;
//}
#region �����ֶδ���
//���Զ���-�����ֶδ���
//if (columnName.IndexOf("_iAuthority") > 0)
//{
// continue;
//}
//if ((columnName.IndexOf("_cLang") > 0) && (columnType.Trim().ToLower() == "varchar"))//���Դ���
//{
// strclass.AppendSpaceLine(2, "BLL.SysManage.MultiLanguage bllML = new BLL.SysManage.MultiLanguage();");
// strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text= bllML.GetLanguageNameByCache(model." + columnName + ");");
// continue;
//}
//if ((!ishasuser) && ((columnName.IndexOf("_iCreator") > 0) || (columnName.IndexOf("_iMaintainer") > 0)))
//{
// strclass.AppendSpaceLine(2, "Maticsoft.Accounts.Bus.User user = new Maticsoft.Accounts.Bus.User();");
// ishasuser = true;
//}
//if ((columnName.IndexOf("_iCreator") > 0) || (columnName.IndexOf("_iMaintainer") > 0))
//{
// strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text= user.GetTrueNameByCache(model." + columnName + ");");
// ishasuser = true;
// continue;
//}
#endregion
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "long":
case "smallint":
case "float":
case "numeric":
case "decimal":
case "datetime":
case "smalldatetime":
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();");
break;
case "bool":
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + "?\"��\":\"��\";");
break;
case "byte[]":
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();");
break;
case "guid":
case "uniqueidentifier":
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ".ToString();");
break;
default:
strclass.AppendSpaceLine(2, "this.lbl" + columnName + ".Text=model." + columnName + ";");
break;
}
}
strclass.AppendLine();
strclass.AppendSpaceLine(1, "}");
return strclass.ToString();
}
/// <summary>
/// 修改窗体的html代码
/// </summary>
public string GetUpdateDesigner()
{
StringPlus strclass = new StringPlus();
return(strclass.Value);
}
/// <summary>
/// �õ���ʾ�����Ӵ����html����
/// </summary>
public string GetUpdateAspx()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine("");
strclass.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">");
bool hasDate = false;
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
if (isFilterColume(columnName))
{
continue;
}
if ((ispk) || (IsIdentity) || (columnType.Trim().ToLower() == "uniqueidentifier"))
{
strclass.AppendSpaceLine(1, "<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">");
strclass.AppendSpaceLine(2, deText);
strclass.AppendSpaceLine(1, "��</td>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">");
strclass.AppendSpaceLine(2, "<asp:label id=\"lbl" + columnName + "\" runat=\"server\"></asp:label>");
strclass.AppendSpaceLine(1, "</td></tr>");
}
else
{
//
strclass.AppendSpaceLine(1, "<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">");
strclass.AppendSpaceLine(2, deText);
strclass.AppendSpaceLine(1, "��</td>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">");
switch (columnType.Trim().ToLower())
{
case "datetime":
case "smalldatetime":
//strclass.AppendSpaceLine(2, "<INPUT onselectstart=\"return false;\" onkeypress=\"return false\" id=\"txt" + columnName + "\" onfocus=\"setday(this)\"");
//strclass.AppendSpaceLine(2, " readOnly type=\"text\" size=\"10\" name=\"Text1\" runat=\"server\">");
strclass.AppendSpaceLine(2, "<asp:TextBox ID=\"txt" + columnName + "\" runat=\"server\" Width=\"70px\" onfocus=\"setday(this)\"></asp:TextBox>");
hasDate = true;
break;
case "bit":
strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />");
break;
default:
strclass.AppendSpaceLine(2, "<asp:TextBox id=\"txt" + columnName + "\" runat=\"server\" Width=\"200px\"></asp:TextBox>");
break;
}
strclass.AppendSpaceLine(1, "</td></tr>");
}
}
////��ť
//strclass.AppendSpaceLine(1, "<tr>");
//strclass.AppendSpaceLine(1, "<td height=\"25\" colspan=\"2\"><div align=\"center\">");
//strclass.AppendSpaceLine(2, "<asp:Button ID=\"btnSave\" runat=\"server\" Text=\"�� ���� ��\" OnClick=\"btnSave_Click\" ></asp:Button>");
////strclass.AppendSpaceLine(2, "<asp:Button ID=\"btnCancel\" runat=\"server\" Text=\"�� ȡ�� ��\" OnClick=\"btnCancel_Click\" ></asp:Button>");
//strclass.AppendSpaceLine(1, "</div></td></tr>");
strclass.AppendLine("</table>");
if (hasDate)
{
strclass.AppendLine("<script src=\"/js/calendar1.js\" type=\"text/javascript\"></script>");
}
return strclass.Value;
}
/// <summary>
/// 生成数据库表创建脚本
/// </summary>
/// <returns></returns>
public string CreateTabScript(string dbname, string tablename)
{
dbobj.DbConnectStr = _dbconnectStr;
List <ColumnInfo> collist = dbobj.GetColumnInfoList(dbname, tablename);
DataTable dt = LTP.CodeHelper.CodeCommon.GetColumnInfoDt(collist);
StringPlus strclass = new StringPlus();
//string PKfild="";//主键字段
//bool IsIden=false;//是否是标识字段
StringPlus ColdefaVal = new StringPlus(); //字段的默认值列表
Hashtable FildtabList = new Hashtable(); //字段列表
StringPlus FildList = new StringPlus(); //字段列表
//开始创建表
strclass.AppendLine("");
strclass.AppendLine(dbobj.GetTableScript(dbname, tablename));
strclass.AppendLine(";");
if (dt != null)
{
DataRow[] dtrows;
if (Fieldlist.Count > 0)
{
dtrows = dt.Select("ColumnName in (" + Fields + ")", "colorder asc");
}
else
{
dtrows = dt.Select();
}
foreach (DataRow row in dtrows)
{
string columnName = row["ColumnName"].ToString();
string columnType = row["TypeName"].ToString();
string IsIdentity = row["IsIdentity"].ToString();
if (IsIdentity == "√")
{
continue;
}
FildtabList.Add(columnName, columnType);
FildList.Append("" + columnName + ",");
}
}
FildList.DelLastComma();
//获取数据
DataTable dtdata = dbobj.GetTabData(dbname, tablename);
if (dtdata != null)
{
foreach (DataRow row in dtdata.Rows) //循环表数据
{
StringPlus strfild = new StringPlus();
StringPlus strdata = new StringPlus();
string [] split = FildList.Value.Split(new Char [] { ',' });
foreach (string fild in split) //循环一行数据的各个字段
{
string colname = fild;
string coltype = "";
foreach (DictionaryEntry myDE in FildtabList)
{
if (myDE.Key.ToString() == colname)
{
coltype = myDE.Value.ToString();
}
}
string strval = "";
switch (coltype)
{
case "binary":
{
byte[] bys = (byte[])row[colname];
strval = LTP.CodeHelper.CodeCommon.ToHexString(bys);
}
break;
case "bit":
{
strval = (row[colname].ToString().ToLower() == "true")?"1":"0";
}
break;
default:
strval = row[colname].ToString().Trim();
break;
}
if (strval != "")
{
if (LTP.CodeHelper.CodeCommon.IsAddMark(coltype))
{
strdata.Append("'" + strval + "',");
}
else
{
strdata.Append(strval + ",");
}
strfild.Append("" + colname + ",");
}
}
strfild.DelLastComma();
strdata.DelLastComma();
//导出数据INSERT语句
strclass.Append("INSERT " + tablename + " (");
strclass.Append(strfild.Value);
strclass.Append(") VALUES ( ");
strclass.Append(strdata.Value); //数据值
strclass.AppendLine(");");
}
}
return(strclass.Value);
}
/// <summary>
/// �Ĵ����html����
/// </summary>
public string GetUpdateDesigner()
{
StringPlus strclass = new StringPlus();
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
if (isFilterColume(columnName))
{
continue;
}
if ((ispk) || (IsIdentity) || (columnType.Trim().ToLower() == "uniqueidentifier"))
{
strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Label lbl" + columnName + ";");
}
else
{
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "datetime":
case "smalldatetime":
strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.TextBox txt" + columnName + ";");
break;
case "bool":
strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.CheckBox chk" + columnName + ";");
break;
default:
strclass.AppendSpaceLine(2, "protected global::System.Web.UI.WebControls.TextBox txt" + columnName + ";");
break;
}
}
}
//��ť
strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Button btnSave;");
strclass.AppendSpaceLine(1, "protected global::System.Web.UI.WebControls.Button btnCancel;");
return strclass.Value;
}
/// <summary>
/// 生成数据库表创建脚本到文件
/// </summary>
/// <returns></returns>
public void CreateTabScript(string dbname, string tablename, string filename, System.Windows.Forms.ProgressBar progressBar)
{
StreamWriter sw = new StreamWriter(filename, true, Encoding.Default); //,false);
dbobj.DbConnectStr = _dbconnectStr;
//DataTable dt=dbobj.GetColumnInfoList(dbname,tablename);
List <ColumnInfo> collist = dbobj.GetColumnInfoList(dbname, tablename);
DataTable dt = LTP.CodeHelper.CodeCommon.GetColumnInfoDt(collist);
StringPlus strclass = new StringPlus();
//strclass.AppendLine("if exists (select * from sysobjects where id = OBJECT_ID('["+tablename+"]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) ");
//strclass.AppendLine("DROP TABLE '"+tablename+"'");
//string PKfild="";//主键字段
//bool IsIden=false;//是否是标识字段
StringPlus ColdefaVal = new StringPlus(); //字段的默认值列表
Hashtable FildtabList = new Hashtable(); //字段列表
StringPlus FildList = new StringPlus(); //字段列表
strclass.AppendLine("");
strclass.AppendLine(dbobj.GetTableScript(dbname, tablename));
strclass.AppendLine(";");
if (dt != null)
{
DataRow[] dtrows;
if (Fieldlist.Count > 0)
{
dtrows = dt.Select("ColumnName in (" + Fields + ")", "colorder asc");
}
else
{
dtrows = dt.Select();
}
foreach (DataRow row in dtrows)
{
string columnName = row["ColumnName"].ToString();
string columnType = row["TypeName"].ToString();
string IsIdentity = row["IsIdentity"].ToString();
if (IsIdentity == "√")
{
continue;
}
FildtabList.Add(columnName, columnType);
FildList.Append("" + columnName + ",");
}
}
FildList.DelLastComma();
sw.Write(strclass.Value);
#region 生成数据脚本
//获取数据
DataTable dtdata = dbobj.GetTabData(dbname, tablename);
if (dtdata != null)
{
int i = 0;
progressBar.Maximum = dtdata.Rows.Count;
foreach (DataRow row in dtdata.Rows) //循环表数据
{
i++;
progressBar.Value = i;
StringPlus rowdata = new StringPlus();
StringPlus strfild = new StringPlus();
StringPlus strdata = new StringPlus();
string [] split = FildList.Value.Split(new Char [] { ',' });
foreach (string fild in split) //循环一行数据的各个字段
{
string colname = fild;
string coltype = "";
foreach (DictionaryEntry myDE in FildtabList)
{
if (myDE.Key.ToString() == colname)
{
coltype = myDE.Value.ToString();
}
}
string strval = "";
switch (coltype)
{
case "binary":
{
byte[] bys = (byte[])row[colname];
strval = LTP.CodeHelper.CodeCommon.ToHexString(bys);
}
break;
case "bit":
{
strval = (row[colname].ToString().ToLower() == "true")?"1":"0";
}
break;
default:
strval = row[colname].ToString().Trim();
break;
}
if (strval != "")
{
if (LTP.CodeHelper.CodeCommon.IsAddMark(coltype))
{
strdata.Append("'" + strval + "',");
}
else
{
strdata.Append(strval + ",");
}
strfild.Append("" + colname + ",");
}
}
strfild.DelLastComma();
strdata.DelLastComma();
//导出数据INSERT语句
rowdata.Append("INSERT " + tablename + " (");
rowdata.Append(strfild.Value);
rowdata.Append(") VALUES ( ");
rowdata.Append(strdata.Value); //数据值
rowdata.AppendLine(");");
sw.Write(rowdata.Value);
}
}
#endregion
sw.Flush();
sw.Close();
}
public static string ViewTxtList(int top, int txtNum, string strWhere, string orderby, string txtUrl)
{
DtCms.BLL.Contents bll = new DtCms.BLL.Contents();
StringBuilder strTxt = new StringBuilder();
DataSet ds = bll.GetList(top, strWhere, orderby);
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
strTxt.Append("<tr><td height=\"30\" align=\"left\" class=\"xuxian-heng\">▪ <a href=\"" + txtUrl + "?id=" + dr["Id"].ToString() + "\" title=\"" + dr["Title"].ToString() + "\">" + StringPlus.CutString(dr["Title"].ToString(), txtNum) + "</a></td></tr>\n");
}
}
return(strTxt.ToString());
}
/// <summary>
/// 得到整个类的代码
/// </summary>
public string GetDALCode(bool Maxid, bool Exists, bool Add, bool Update, bool Delete, bool GetModel, bool List)
{
StringPlus strclass = new StringPlus();
strclass.AppendLine("using System;");
strclass.AppendLine("using System.Data;");
strclass.AppendLine("using System.Text;");
switch (dbobj.DbType)
{
case "SQL2005":
strclass.AppendLine("using System.Data.SqlClient;");
break;
case "SQL2000":
strclass.AppendLine("using System.Data.SqlClient;");
break;
case "Oracle":
strclass.AppendLine("using System.Data.OracleClient;");
break;
case "MySQL":
strclass.AppendLine("using MySql.Data.MySqlClient;");
break;
case "OleDb":
strclass.AppendLine("using System.Data.OleDb;");
break;
}
if (IDALpath != "")
{
strclass.AppendLine("using " + IDALpath + ";");
}
strclass.AppendLine("using Maticsoft.DBUtility;//请先添加引用");
strclass.AppendLine("namespace " + DALpath);
strclass.AppendLine("{");
strclass.AppendSpaceLine(1, "/// <summary>");
strclass.AppendSpaceLine(1, "/// 数据访问类" + DALName + "。");
strclass.AppendSpaceLine(1, "/// </summary>");
strclass.AppendSpace(1, "public class " + DALName);
if (IClass != "")
{
strclass.Append(":" + IClass);
}
strclass.AppendLine("");
strclass.AppendSpaceLine(1, "{");
strclass.AppendSpaceLine(2, "public " + DALName + "()");
strclass.AppendSpaceLine(2, "{}");
strclass.AppendSpaceLine(2, "#region 成员方法");
#region 方法代码
if (Maxid)
{
strclass.AppendLine(CreatGetMaxID());
}
if (Exists)
{
strclass.AppendLine(CreatExists());
}
if (Add)
{
strclass.AppendLine(CreatAdd());
}
if (Update)
{
strclass.AppendLine(CreatUpdate());
}
if (Delete)
{
strclass.AppendLine(CreatDelete());
}
if (GetModel)
{
strclass.AppendLine(CreatGetModel());
}
if (List)
{
strclass.AppendLine(CreatGetList());
strclass.AppendLine(CreatGetListByPageProc());
}
#endregion
strclass.AppendSpaceLine(2, "#endregion 成员方法");
strclass.AppendSpaceLine(1, "}");
strclass.AppendLine("}");
strclass.AppendLine("");
return(strclass.ToString());
}
/// <summary>
/// 按字节长度剪切字符串
/// </summary>
/// <param name="str"></param>
/// <param name="byteLength"></param>
/// <param name="isDot">是否末尾加 ...</param>
/// <returns></returns>
public string GetStrByByteLength(string str, int byteLength, bool isDot)
{
return(StringPlus.GetStrByByteLength(str, byteLength, isDot));
}
/// <summary>
/// 得到GetModel()的代码
/// </summary>
/// <param name="DbName"></param>
/// <param name="_tablename"></param>
/// <param name="_key"></param>
/// <param name="ModelName"></param>
/// <returns></returns>
public string CreatGetModel()
{
if (ModelSpace == "")
{
//ModelSpace = "ModelClassName"; ;
}
StringPlus strclass = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// 得到一个对象实体");
strclass.AppendSpaceLine(2, "/// </summary>");
strclass.AppendSpaceLine(2, "public " + ModelSpace + " GetModel(" + LTP.CodeHelper.CodeCommon.GetInParameter(Keys) + ")");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, KeysNullTip);
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpace(3, "strSql.Append(\"select ");
if (dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2008")
{
strclass.Append(" top 1 ");
}
strclass.AppendLine(Fieldstrlist + " from " + _tablename + " \");");
strclass.AppendSpaceLine(3, "strSql.Append(\" where " + GetWhereExpression(Keys) + "\");");
strclass.AppendLine(GetPreParameter(Keys));
strclass.AppendSpaceLine(3, "" + ModelSpace + " model=new " + ModelSpace + "();");
strclass.AppendSpaceLine(3, "DataSet ds=" + DbHelperName + ".Query(strSql.ToString(),parameters);");
strclass.AppendSpaceLine(3, "if(ds.Tables[0].Rows.Count>0)");
strclass.AppendSpaceLine(3, "{");
#region 字段赋值
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
switch (CodeCommon.DbTypeToCS(columnType))
{
case "int":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=int.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "long":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=long.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "decimal":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=decimal.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "float":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=float.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "DateTime":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=DateTime.Parse(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
case "string":
{
strclass.AppendSpaceLine(4, "model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();");
}
break;
case "bool":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "if((ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()==\"1\")||(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString().ToLower()==\"true\"))");
strclass.AppendSpaceLine(5, "{");
strclass.AppendSpaceLine(6, "model." + columnName + "=true;");
strclass.AppendSpaceLine(5, "}");
strclass.AppendSpaceLine(5, "else");
strclass.AppendSpaceLine(5, "{");
strclass.AppendSpaceLine(6, "model." + columnName + "=false;");
strclass.AppendSpaceLine(5, "}");
strclass.AppendSpaceLine(4, "}");
}
break;
case "byte[]":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=(byte[])ds.Tables[0].Rows[0][\"" + columnName + "\"];");
strclass.AppendSpaceLine(4, "}");
}
break;
case "Guid":
{
strclass.AppendSpaceLine(4, "if(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString()!=\"\")");
strclass.AppendSpaceLine(4, "{");
strclass.AppendSpaceLine(5, "model." + columnName + "=new Guid(ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString());");
strclass.AppendSpaceLine(4, "}");
}
break;
default:
strclass.AppendSpaceLine(4, "//model." + columnName + "=ds.Tables[0].Rows[0][\"" + columnName + "\"].ToString();");
break;
}
}
#endregion
strclass.AppendSpaceLine(4, "return model;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return null;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(2, "}");
return(strclass.ToString());
}
/// <summary>
/// 得到修改窗体的代码
/// </summary>
public string GetUpdateAspxCs()
{
StringPlus strclass = new StringPlus();
StringPlus strclass0 = new StringPlus();
StringPlus strclass1 = new StringPlus();
StringPlus strclass2 = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(3, "string strErr=\"\";");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
bool ispk = field.IsPK;
bool IsIdentity = field.IsIdentity;
if ((ispk) || (IsIdentity))
{
continue;
}
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "smallint":
strclass0.AppendSpaceLine(3, "int " + columnName + "=int.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsNumber(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + columnName + "不是数字！\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
case "float":
case "numeric":
case "decimal":
strclass0.AppendSpaceLine(3, "decimal " + columnName + "=decimal.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDecimal(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + columnName + "不是数字！\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
case "datetime":
case "smalldatetime":
strclass0.AppendSpaceLine(3, "DateTime " + columnName + "=DateTime.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDateTime(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + columnName + "不是时间格式！\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
case "bool":
strclass0.AppendSpaceLine(3, "bool " + columnName + "=this.chk" + columnName + ".Checked;");
break;
case "byte[]":
strclass0.AppendSpaceLine(3, "byte[] " + columnName + "= new UnicodeEncoding().GetBytes(this.txt" + columnName + ".Text);");
break;
default:
strclass0.AppendSpaceLine(3, "string " + columnName + "=this.txt" + columnName + ".Text;");
strclass1.AppendSpaceLine(3, "if(this.txt" + columnName + ".Text ==\"\")");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + columnName + "不能为空！\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
}
strclass2.AppendSpaceLine(3, "model." + columnName + "=" + columnName + ";");
}
strclass.AppendLine(strclass1.ToString());
strclass.AppendSpaceLine(3, "if(strErr!=\"\")");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "MessageBox.Show(this,strErr);");
strclass.AppendSpaceLine(4, "return;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendLine(strclass0.ToString());
strclass.AppendLine();
strclass.AppendSpaceLine(3, ModelSpace + " model=new " + ModelSpace + "();");
strclass.AppendLine(strclass2.ToString());
strclass.AppendSpaceLine(3, BLLSpace + " bll=new " + BLLSpace + "();");
strclass.AppendSpaceLine(3, "bll.Update(model);");
return(strclass.ToString());
}
/// <summary>
/// ����sql����еIJ����б�(���磺���� Exists Delete GetModel ��where������ֵ)
/// </summary>
/// <param name="keys"></param>
/// <returns></returns>
public string GetPreParameter(List<ColumnInfo> keys, bool IdentityisPrior)
{
StringPlus strclass = new StringPlus();
StringPlus strclass2 = new StringPlus();
strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {");
ColumnInfo field = Maticsoft.CodeHelper.CodeCommon.GetIdentityKey(keys);
if ((IdentityisPrior) && (field != null)) //�б�ʶ�ֶ�
{
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "" + field.ColumnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, field.TypeName, "") + ")");
strclass2.AppendSpaceLine(3, "parameters[0].Value = " + field.ColumnName + ";");
}
else
{
int n = 0;
foreach (ColumnInfo key in keys)
{
if (key.IsPrimaryKey)
{
strclass.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + "" + key.ColumnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, key.TypeName, "") + "),");
strclass2.AppendSpaceLine(3, "parameters[" + n.ToString() + "].Value = " + key.ColumnName + ";");
n++;
}
}
strclass.DelLastComma();
}
strclass.AppendLine("};");
strclass.Append(strclass2.Value);
return strclass.Value;
}
public string CreatSearchForm()
{
StringPlus strclass = new StringPlus();
return(strclass.Value);
}
/// <summary>
/// ���ɱ�ʾ��ҳ���CS����
/// </summary>
/// <param name="ExistsKey"></param>
/// <param name="AddForm">�Ƿ��������Ӵ���Ĵ���</param>
/// <param name="UpdateForm">�Ƿ������Ĵ���Ĵ���</param>
/// <param name="ShowForm">�Ƿ�������ʾ����Ĵ���</param>
/// <param name="SearchForm">�Ƿ����ɲ�ѯ����Ĵ���</param>
/// <returns></returns>
public string GetWebCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm)
{
StringPlus strclass = new StringPlus();
if (AddForm)
{
strclass.AppendLine(" /******************************���Ӵ������********************************/");
strclass.AppendLine(GetAddAspxCs());
}
if (UpdateForm)
{
strclass.AppendLine(" /******************************�Ĵ������********************************/");
strclass.AppendLine(" /*�Ĵ���-��ʾ */");
strclass.AppendLine(GetUpdateShowAspxCs());
strclass.AppendLine(" /*�Ĵ���-�ύ���� */");
strclass.AppendLine(GetUpdateAspxCs());
}
if (ShowForm)
{
strclass.AppendLine(" /******************************��ʾ�������********************************/");
strclass.AppendLine(GetShowAspxCs());
}
//if (DelForm)
//{
// strclass.Append(" /******************************ɾ���������********************************/");
// strclass.Append("");
// strclass.Append(CreatDeleteForm());
//}
return strclass.Value;
}
/// <summary>
/// 显示窗体的html代码
/// </summary>
public string GetShowDesigner()
{
StringPlus strclass = new StringPlus();
return(strclass.ToString());
}
/// <summary>
/// ��ɾ��3��ҳ�����
/// </summary>
public string GetWebHtmlCode(bool ExistsKey, bool AddForm, bool UpdateForm, bool ShowForm, bool SearchForm)
{
StringPlus strclass = new StringPlus();
if (AddForm)
{
strclass.AppendLine(" <!--******************************����ҳ�����********************************-->");
strclass.AppendLine(GetAddAspx());
}
if (UpdateForm)
{
strclass.AppendLine(" <!--******************************��ҳ�����********************************-->");
strclass.AppendLine(GetUpdateAspx());
}
if (ShowForm)
{
strclass.AppendLine(" <!--******************************��ʾҳ�����********************************-->");
strclass.AppendLine(GetShowAspx());
}
if (SearchForm)
{
strclass.AppendLine(" <!--******************************�б�ҳ�����********************************-->");
strclass.AppendLine(GetListAspx());
}
return strclass.ToString();
}
/// <summary>
/// 根据SQL查询结果 生成数据创建脚本
/// </summary>
/// <returns></returns>
public string CreateTabScriptBySQL(string dbname, string strSQL)
{
dbobj.DbConnectStr = _dbconnectStr;
//string PKfild = "";//主键字段
bool IsIden = false;//是否是标识字段
string tablename = "TableName";
StringPlus strclass = new StringPlus();
#region 查询表名
int ns = strSQL.IndexOf(" from ");
if (ns > 0)
{
string sqltemp = strSQL.Substring(ns + 5).Trim();
int ns2 = sqltemp.IndexOf(" ");
if (sqltemp.Length > 0)
{
if (ns2 > 0)
{
tablename = sqltemp.Substring(0, ns2).Trim();
}
else
{
tablename = sqltemp.Substring(0).Trim();
}
}
}
tablename = tablename.Replace("[", "").Replace("]", "");
#endregion
#region 数据脚本
//获取数据
DataTable dtdata = dbobj.GetTabDataBySQL(dbname, strSQL);
if (dtdata != null)
{
DataColumnCollection dtcols = dtdata.Columns;
foreach (DataRow row in dtdata.Rows)//循环表数据
{
StringPlus strfild = new StringPlus();
StringPlus strdata = new StringPlus();
foreach (DataColumn col in dtcols)//循环一行数据的各个字段
{
string colname = col.ColumnName;
string coltype = col.DataType.Name;
if (col.AutoIncrement)
{
IsIden = true;
}
string strval = "";
switch (coltype.ToLower())
{
case "binary":
case "byte[]":
case "blob":
{
byte[] bys = (byte[])row[colname];
strval = LTP.CodeHelper.CodeCommon.ToHexString(bys);
}
break;
case "bit":
case "boolean":
{
strval = (row[colname].ToString().ToLower() == "true") ? "1" : "0";
}
break;
default:
strval = row[colname].ToString().Trim();
break;
}
if (strval != "")
{
if (LTP.CodeHelper.CodeCommon.IsAddMark(coltype))
{
strdata.Append("'" + strval + "',");
}
else
{
strdata.Append(strval + ",");
}
strfild.Append("" + colname + ",");
}
}
strfild.DelLastComma();
strdata.DelLastComma();
//导出数据INSERT语句
strclass.Append("INSERT " + tablename + " (");
strclass.Append(strfild.Value);
strclass.Append(") VALUES ( ");
strclass.Append(strdata.Value);//数据值
strclass.AppendLine(")");
}
}
//StringPlus strclass0 = new StringPlus();
//if (IsIden)
//{
// strclass0.AppendLine("SET IDENTITY_INSERT [" + tablename + "] ON");
// strclass0.AppendLine("");
//}
//strclass0.AppendLine(strclass.Value);
//if (IsIden)
//{
// strclass0.AppendLine("");
// strclass0.AppendLine("SET IDENTITY_INSERT [" + tablename + "] OFF");
//}
#endregion
return(strclass.Value);
}
public string CreatSearchForm()
{
StringPlus strclass = new StringPlus();
return strclass.Value;
}
public string CreatPROCUpdate()
{
StringPlus strclass = new StringPlus();
StringPlus strclass1 = new StringPlus();
//strclass.Append("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[");
//strclass.Append("" + ProcPrefix + ""+_tablename+"_Update");
//strclass.AppendLine("]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)");
//strclass.AppendLine("drop procedure [dbo].[" + ProcPrefix + ""+_tablename+"_Update]");
//strclass.AppendLine("GO");
strclass.AppendLine("------------------------------------");
strclass.AppendLine("--用途：修改一条记录 ");
strclass.AppendLine("--项目名称：" + ProjectName);
strclass.AppendLine("--说明：");
strclass.AppendLine("--时间：" + DateTime.Now.ToString());
strclass.AppendLine("------------------------------------");
strclass.AppendLine("CREATE PROCEDURE " + ProcPrefix + "" + _tablename + "_Update");
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
bool IsIdentity = field.IsIdentity;
bool IsPK = field.IsPK;
string Length = field.Length;
string Preci = field.Preci;
string Scale = field.Scale;
switch (columnType.ToLower())
{
case "decimal":
case "numeric":
strclass.AppendLine("@" + columnName + " " + columnType + "(" + Preci + "," + Scale + "),");
break;
case "varchar":
case "char":
case "nchar":
case "binary":
case "nvarchar":
case "varbinary":
{
string len = CodeCommon.GetDataTypeLenVal(columnType.Trim(), Length);
strclass.AppendLine("@" + columnName + " " + columnType + "(" + len + "),");
}
break;
default:
strclass.AppendLine("@" + columnName + " " + columnType + ",");
break;
}
if ((IsIdentity) || (IsPK))
{
continue;
}
strclass1.Append("" + columnName + " = @" + columnName + ",");
}
strclass.DelLastComma();
strclass1.DelLastComma();
strclass.AppendLine();
strclass.AppendLine(" AS ");
strclass.AppendSpaceLine(1, "UPDATE " + _tablename + " SET ");
strclass.AppendSpaceLine(1, strclass1.Value);
strclass.AppendSpaceLine(1, "WHERE " + GetWhereExpression(Keys));
strclass.AppendLine();
strclass.AppendLine("GO");
return(strclass.Value);
}
/// <summary>
/// �õ���ʾ�����Ӵ����html����
/// </summary>
public string GetAddAspx()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
strclass.AppendLine("<table cellSpacing=\"0\" cellPadding=\"0\" width=\"100%\" border=\"0\">");
bool hasDate = false;
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
if (IsIdentity)
{
continue;
}
if (isFilterColume(columnName))
{
continue;
}
if (columnType.Trim().ToLower() == "uniqueidentifier")
{
continue;
}
deText = CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
strclass.AppendSpaceLine(1, "<tr>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"30%\" align=\"right\">");
strclass.AppendSpaceLine(2, deText);
strclass.AppendSpaceLine(1, "��</td>");
strclass.AppendSpaceLine(1, "<td height=\"25\" width=\"*\" align=\"left\">");
switch (columnType.Trim().ToLower())
{
case "datetime":
case "smalldatetime":
strclass.AppendSpaceLine(2, "<asp:TextBox ID=\"txt" + columnName + "\" runat=\"server\" Width=\"70px\" onfocus=\"setday(this)\"></asp:TextBox>");
hasDate = true;
break;
case "bit":
strclass.AppendSpaceLine(2, "<asp:CheckBox ID=\"chk" + columnName + "\" Text=\"" + deText + "\" runat=\"server\" Checked=\"False\" />");
break;
case "uniqueidentifier":
break;
default:
strclass.AppendSpaceLine(2, "<asp:TextBox id=\"txt" + columnName + "\" runat=\"server\" Width=\"200px\"></asp:TextBox>");
break;
}
strclass.AppendSpaceLine(1, "</td></tr>");
}
strclass.AppendLine("</table>");
if (hasDate)
{
strclass.AppendLine("<script src=\"/js/calendar1.js\" type=\"text/javascript\"></script>");
}
return strclass.ToString();
}
public IndicAkshar[] Split(string s)
{
IndicAkshar[] IA = null;
try
{
string[] retVal = new string[s.Length];
int cnt = 0;
string lockedString = "";
char lastChar = ' ';
string lastCharNature = "a";
bool released = false;
for (int i = 0; i < s.Length; i++)
{
released = false;
char currChar = StringPlus.CharAt(s, i);
IndicChar I = _ic.NewChar;
I.CharSet = CharSet;
I.BaseChar = currChar;
if (currChar == this.CharSet.Special2)
{
if (cnt >= 1)
{
retVal[cnt - 1] = retVal[cnt - 1] + currChar;
continue;
}
}
string currCharNature = I.CharNature;
bool CanIRelase = CanRelease(currCharNature, lastCharNature);
if (CanIRelase)
{
bool CanImmRelase = IsImmRelease(currCharNature);
if (CanImmRelase)
{
if (lockedString != "")
{
retVal[cnt++] = lockedString;
}
lockedString = currChar.ToString();
released = false;
}
else
{
#region NotImmRElease
if (I.IsSpecialFinishing || I.IsNeutral)
{
#region SpecialCharFinishing
if (lockedString == "")
{
try
{
retVal[cnt - 1] = retVal[cnt - 1] + lockedString + currChar;
}
catch
{
throw new Exception("Invalid Lang Char ");
}
}
else
{
retVal[cnt++] = lockedString + currChar;
}
#endregion
}
else
{
if (!I.CanIgonre)
{
lockedString = lockedString + currChar;
if (lockedString != "")
{
retVal[cnt++] = lockedString;
}
}
else
{
if (lockedString != "")
{
retVal[cnt++] = lockedString;
}
retVal[cnt++] = currChar.ToString();
}
}
lockedString = "";
released = true;
#endregion
}
lastChar = ' ';
lastCharNature = currCharNature;
}
else
{
lastChar = currChar;
lockedString = lockedString + currChar;
lastCharNature = currCharNature;
}
}
if (!released)
{
retVal[cnt++] = lockedString;
}
IA = new IndicAkshar[cnt];
for (int i = 0; i < cnt; i++)
{
IA[i] = new IndicAkshar();
IA[i].SetChars(retVal[i], this.CharSet);
}
}
catch
{
}
return(IA);
}
/// <summary>
/// �õ���ʾ�����Ӵ���Ĵ���
/// </summary>
public string GetAddAspxCs()
{
StringPlus strclass = new StringPlus();
StringPlus strclass0 = new StringPlus();
StringPlus strclass1 = new StringPlus();
StringPlus strclass2 = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(3, "string strErr=\"\";");
//bool ishasuser = false;
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
if ((IsIdentity))
{
continue;
}
if ("uniqueidentifier" == columnType.ToLower())
{
continue;
}
//���Զ���-�����ֶδ���
//if ((!ishasuser) && ((columnName.IndexOf("_iCreator") > 0) || (columnName.IndexOf("_iMaintainer") > 0)))
//{
// strclass0.AppendSpaceLine(3, "User currentUser;");
// strclass0.AppendSpaceLine(3, "if (Session[\"UserInfo\"] != null)");
// strclass0.AppendSpaceLine(3, "{");
// strclass0.AppendSpaceLine(4, "currentUser = (User)Session[\"UserInfo\"];");
// strclass0.AppendSpaceLine(3, "}else{");
// strclass0.AppendSpaceLine(4, "return;");
// strclass0.AppendSpaceLine(3, "}");
// ishasuser = true;
//}
deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
switch (CodeCommon.DbTypeToCS(columnType.Trim().ToLower()).ToLower())
{
case "int":
case "smallint":
strclass0.AppendSpaceLine(3, "int " + columnName + "=int.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsNumber(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
case "float":
case "numeric":
case "decimal":
strclass0.AppendSpaceLine(3, "decimal " + columnName + "=decimal.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDecimal(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
case "datetime":
case "smalldatetime":
strclass0.AppendSpaceLine(3, "DateTime " + columnName + "=DateTime.Parse(this.txt" + columnName + ".Text);");
strclass1.AppendSpaceLine(3, "if(!PageValidate.IsDateTime(txt" + columnName + ".Text))");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "��ʽ����\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
case "bool":
strclass0.AppendSpaceLine(3, "bool " + columnName + "=this.chk" + columnName + ".Checked;");
break;
case "byte[]":
strclass0.AppendSpaceLine(3, "byte[] " + columnName + "= new UnicodeEncoding().GetBytes(this.txt" + columnName + ".Text);");
break;
case "guid":
case "uniqueidentifier":
break;
default:
strclass0.AppendSpaceLine(3, "string " + columnName + "=this.txt" + columnName + ".Text;");
strclass1.AppendSpaceLine(3, "if(this.txt" + columnName + ".Text.Trim().Length==0)");
strclass1.AppendSpaceLine(3, "{");
strclass1.AppendSpaceLine(4, "strErr+=\"" + deText + "����Ϊ�գ�\\\\n\"; ");
strclass1.AppendSpaceLine(3, "}");
break;
}
strclass2.AppendSpaceLine(3, "model." + columnName + "=" + columnName + ";");
}
strclass.AppendLine(strclass1.ToString());
strclass.AppendSpaceLine(3, "if(strErr!=\"\")");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "MessageBox.Show(this,strErr);");
strclass.AppendSpaceLine(4, "return;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendLine(strclass0.ToString());
strclass.AppendSpaceLine(3, ModelSpace + " model=new " + ModelSpace + "();");
strclass.AppendLine(strclass2.ToString());
strclass.AppendSpaceLine(3, BLLSpace + " bll=new " + BLLSpace + "();");
strclass.AppendSpaceLine(3, "bll.Add(model);");
strclass.AppendSpaceLine(3, NameSpace + ".Common.MessageBox.ShowAndRedirect(this,\"����ɹ���\",\"add.aspx\");");
return strclass.Value;
}
/// <summary>
/// 得到Add()的代码
/// </summary>
public string CreatAdd()
{
if (ModelSpace == "")
{
//ModelSpace = "ModelClassName"; ;
}
StringPlus strclass = new StringPlus();
StringPlus strclass1 = new StringPlus();
StringPlus strclass2 = new StringPlus();
StringPlus strclass3 = new StringPlus();
StringPlus strclass4 = new StringPlus();
strclass.AppendLine();
strclass.AppendSpaceLine(2, "/// <summary>");
strclass.AppendSpaceLine(2, "/// 增加一条数据");
strclass.AppendSpaceLine(2, "/// </summary>");
string strretu = "void";
if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008") && (IsHasIdentity))
{
strretu = "int";
}
//方法定义头
string strFun = CodeCommon.Space(2) + "public " + strretu + " Add(" + ModelSpace + " model)";
strclass.AppendLine(strFun);
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, "StringBuilder strSql=new StringBuilder();");
strclass.AppendSpaceLine(3, "strSql.Append(\"insert into " + _tablename + "(\");");
strclass1.AppendSpace(3, "strSql.Append(\"");
int n = 0;
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
bool IsIdentity = field.IsIdentity;
string Length = field.Length;
if (field.IsIdentity)
{
continue;
}
strclass3.AppendSpaceLine(5, "new " + DbParaHead + "Parameter(\"" + preParameter + columnName + "\", " + DbParaDbType + "." + CodeCommon.DbTypeLength(dbobj.DbType, columnType, Length) + "),");
strclass1.Append(columnName + ",");
strclass2.Append(preParameter + columnName + ",");
strclass4.AppendSpaceLine(3, "parameters[" + n + "].Value = model." + columnName + ";");
n++;
}
//去掉最后的逗号
strclass1.DelLastComma();
strclass2.DelLastComma();
strclass3.DelLastComma();
strclass1.AppendLine(")\");");
strclass.Append(strclass1.ToString());
strclass.AppendSpaceLine(3, "strSql.Append(\" values (\");");
strclass.AppendSpaceLine(3, "strSql.Append(\"" + strclass2.ToString() + ")\");");
if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008") && (IsHasIdentity))
{
strclass.AppendSpaceLine(3, "strSql.Append(\";select @@IDENTITY\");");
}
strclass.AppendSpaceLine(3, "" + DbParaHead + "Parameter[] parameters = {");
strclass.Append(strclass3.Value);
strclass.AppendLine("};");
strclass.AppendLine(strclass4.Value);
//重新定义方法头
if ((dbobj.DbType == "SQL2000" || dbobj.DbType == "SQL2005" || dbobj.DbType == "SQL2008") && (IsHasIdentity))
{
strclass.AppendSpaceLine(3, "object obj = " + DbHelperName + ".GetSingle(strSql.ToString(),parameters);");
strclass.AppendSpaceLine(3, "if (obj == null)");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return 1;");
strclass.AppendSpaceLine(3, "}");
strclass.AppendSpaceLine(3, "else");
strclass.AppendSpaceLine(3, "{");
strclass.AppendSpaceLine(4, "return Convert.ToInt32(obj);");
strclass.AppendSpaceLine(3, "}");
}
else
{
strclass.AppendSpaceLine(3, "" + DbHelperName + ".ExecuteSql(strSql.ToString(),parameters);");
}
strclass.AppendSpace(2, "}");
return(strclass.ToString());
}
/// <summary>
/// ɾ��ҳ��
/// </summary>
/// <returns></returns>
public string GetDeleteAspxCs()
{
StringPlus strclass = new StringPlus();
strclass.AppendSpaceLine(1, "if(!Page.IsPostBack)");
strclass.AppendSpaceLine(2, "{");
strclass.AppendSpaceLine(3, BLLSpace + " bll=new " + BLLSpace + "();");
switch (_keyType.Trim())
{
case "int":
case "long":
case "smallint":
case "float":
case "numeric":
case "decimal":
case "datetime":
case "smalldatetime":
strclass.AppendSpaceLine(3, _keyType + " " + _key + "=" + _keyType + ".Parse(Request.Params[\"id\"]);");
break;
default:
strclass.AppendSpaceLine(3, "string " + _key + "=Request.Params[\"id\"];");
break;
}
strclass.AppendSpaceLine(3, "bll.Delete(" + _key + ");");
strclass.AppendSpaceLine(3, "Response.Redirect(\"list.aspx\");");
strclass.AppendSpaceLine(2, "}");
return strclass.Value;
}
private string BuilderModel()
{
StringPlus plus = new StringPlus();
StringPlus plus2 = new StringPlus();
StringPlus plus3 = new StringPlus();
plus.AppendSpaceLine(2, "#region Model");
foreach (ColumnInfo column in Columns)
{
if (!string.IsNullOrWhiteSpace(column.DefaultVal))
{
var val = "";
if (column.TypeName.ToLower().Contains("bool"))
{
switch (val)
{
case "b'0'":
val = "0";
break;
case "b'1'":
val = "1";
break;
}
val = DataUtils.ConvertValue<bool>(column.DefaultVal) ? "true" : "false";
}
else if (column.TypeName.ToLower().Contains("string"))
{
val = "\"" + column.DefaultVal + "\"";
}
else if (column.TypeName.ToLower().Contains("guid"))
{
Guid tempGuid;
if (Guid.TryParse(column.DefaultVal, out tempGuid))
{
val = "Guid.Parse(\"" + column.DefaultVal + "\")";
}
else
{
val = "Guid.NewGuid()";
}
}
else if (column.TypeName.ToLower().Contains("int"))
{
val = column.DefaultVal;
}
else if (column.TypeName.ToLower().Contains("decimal"))
{
val = column.DefaultVal + "M";
}
else if (column.TypeName.ToLower().Contains("float"))
{
val = column.DefaultVal + "F";
}
if (string.IsNullOrWhiteSpace(val))
{
plus2.AppendSpaceLine(2, "private " + column.TypeName + " _" + column.ColumnName + ";");
}
else
{
plus2.AppendSpaceLine(2, "private " + column.TypeName + " _" + column.ColumnName + " = " + val + ";");
}
}
else
{
plus2.AppendSpaceLine(2, "private " + column.TypeName + " _" + column.ColumnName + ";");
}
plus3.AppendSpaceLine(2, "/// <summary>");
plus3.AppendSpaceLine(2, "/// " + column.DeText);
plus3.AppendSpaceLine(2, "/// </summary>");
plus3.AppendSpaceLine(2, "public " + column.TypeName + " " + column.ColumnName);
plus3.AppendSpaceLine(2, "{");
plus3.AppendSpaceLine(3, "get{ return _" + column.ColumnName + "; }");
plus3.AppendSpaceLine(3, "set");
plus3.AppendSpaceLine(3, "{");
plus3.AppendSpaceLine(4, "this.OnPropertyValueChange(_." + column.ColumnName + ",_" + column.ColumnName + ",value);");
plus3.AppendSpaceLine(4, "this._" + column.ColumnName + "=value;");
plus3.AppendSpaceLine(3, "}");
plus3.AppendSpaceLine(2, "}");
}
plus.Append(plus2.Value);
plus.Append(plus3.Value);
plus.AppendSpaceLine(2, "#endregion");
return plus.ToString();
}
/// <summary>
/// �õ���ʾ���б�����html����
/// </summary>
public string GetListAspx()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
foreach (ColumnInfo field in Fieldlist)
{
string columnName = field.ColumnName;
string columnType = field.TypeName;
string deText = field.Description;
bool ispk = field.IsPrimaryKey;
bool IsIdentity = field.IsIdentity;
deText = Maticsoft.CodeHelper.CodeCommon.CutDescText(deText, 15, columnName);
if (IsIdentity)
{
continue;
}
if (isFilterColume(columnName))
{
continue;
}
switch (columnType.Trim().ToLower())
{
case "bit":
case "dateTime":
strclass.AppendSpaceLine(2, "<asp:BoundField DataField=\"" + columnName + "\" HeaderText=\"" + deText + "\" SortExpression=\"" + columnName + "\" ItemStyle-HorizontalAlign=\"Center\" /> ");
break;
default:
strclass.AppendSpaceLine(2, "<asp:BoundField DataField=\"" + columnName + "\" HeaderText=\"" + deText + "\" SortExpression=\"" + columnName + "\" ItemStyle-HorizontalAlign=\"Center\" /> ");
break;
}
}
return strclass.ToString();
}
public string Builder()
{
Columns = DbToCS.DbtoCSColumns(Columns);
StringPlus plus = new StringPlus();
plus.AppendLine("//------------------------------------------------------------------------------");
plus.AppendLine("// <auto-generated>");
plus.AppendLine("// 此代码由工具生成。");
plus.AppendLine("// 运行时版本:" + Environment.Version.ToString());
plus.AppendLine("// Support: http://www.cnblogs.com/huxj");
plus.AppendLine("// Website: http://ITdos.com/Dos/ORM/Index.html");
plus.AppendLine("// 对此文件的更改可能会导致不正确的行为，并且如果");
plus.AppendLine("// 重新生成代码，这些更改将会丢失。");
plus.AppendLine("// </auto-generated>");
plus.AppendLine("//------------------------------------------------------------------------------");
plus.AppendLine();
plus.AppendLine();
plus.AppendLine("using System;");
plus.AppendLine("using System.Data;");
plus.AppendLine("using System.Data.Common;");
plus.AppendLine("using Dos.ORM;");
plus.AppendLine("using Dos.ORM.Common;");
plus.AppendLine();
plus.AppendLine("namespace " + NameSpace);
plus.AppendLine("{");
plus.AppendLine();
plus.AppendSpaceLine(1, "/// <summary>");
plus.AppendSpaceLine(1, "/// 实体类" + ClassName + " 。(属性说明自动提取数据库字段的描述信息)");
plus.AppendSpaceLine(1, "/// </summary>");
plus.AppendSpaceLine(1, "[Serializable]");
plus.AppendSpaceLine(1, "public partial class " + ClassName + " : Entity ");
plus.AppendSpaceLine(1, "{");
plus.AppendSpaceLine(2, "public " + ClassName + "():base(\"" + TableName + "\") {}");
plus.AppendLine();
plus.AppendLine(BuilderModel());
plus.AppendLine(BuilderMethod());
plus.AppendSpaceLine(1, "}");
plus.AppendLine("}");
plus.AppendLine("");
return plus.ToString();
}
/// <summary>
/// �õ���ʾ���б����Ĵ���
/// </summary>
public string GetListAspxCs()
{
StringPlus strclass = new StringPlus();
strclass.AppendLine();
strclass.AppendSpace(2, BLLSpace + " bll = new " + BLLSpace + "();");
return strclass.ToString();
}
